Error: 18456 Severity: 14 State:11

Hi,
I posted this in the server-group, but no response, I removed the
message and now trying with this group...
I installed a SQL Server 2005 Workgroup on a W2k server.
Every 20 second the SQL errorlog log the two lines below:
DateTime Logon Error: 18456, Severity: 14, State: 11.
DateTime Logon Login failed for user 'DOMAIN\SERVERNAME$'. [CLIENT:
x.x.x.x]
The x.x.x.x is the server's IP.
State 11 means that the login doesn't have access to the server.
Yah...? So...?
The strange thing is that the "user" in this case is my 2003-server
(note the dollar-sign).
Could anyone point me in any direction - I am very lost.
( - and yes, the errorlog-file is now reaching 20MB after 2 weeks of
headless logging...)
Tanx in advance.
/oIt seems like some service on your Win 2003 machine is trying to connect to
the SQL Server instance on the Windows 2000 one.
The machine account (DOMAIN\machine_name$) is typically used when a
service running as system or network service try to access an external
resource, in this case establish a connection to SQL Server.
I would recommend taking a look to all your services and other automated
tasks in the Windows 2003 machine and try to find out which one is the one
trying to connect to SQL Server.
-Raul Garcia
SDE/T
SQL Server Engine
________________________________________
This posting is provided "AS IS" with no warranties, and confers no rights.
"ola.martins@.gmail.com" wrote:

> Hi,
> I posted this in the server-group, but no response, I removed the
> message and now trying with this group...
> I installed a SQL Server 2005 Workgroup on a W2k server.
> Every 20 second the SQL errorlog log the two lines below:
> DateTime Logon Error: 18456, Severity: 14, State: 11.
> DateTime Logon Login failed for user 'DOMAIN\SERVERNAME$'. [CLIENT:
> x.x.x.x]
> The x.x.x.x is the server's IP.
> State 11 means that the login doesn't have access to the server.
> Yah...? So...?
> The strange thing is that the "user" in this case is my 2003-server
> (note the dollar-sign).
> Could anyone point me in any direction - I am very lost.
> ( - and yes, the errorlog-file is now reaching 20MB after 2 weeks of
> headless logging...)
> Tanx in advance.
> /o
>|||Ok,
I'll look in to that.
I've got Brightstor ARCServe Backup installed, but I used the
"sa"-logon when defining the connection.
It's peculiar that something - and that I don't know what it is - is
connecting to the sql server...
Thank you for your response,
/o
Raul skrev:
[vbcol=seagreen]
> It seems like some service on your Win 2003 machine is trying to connect t
o
> the SQL Server instance on the Windows 2000 one.
> The machine account (DOMAIN\machine_name$) is typically used when a
> service running as system or network service try to access an external
> resource, in this case establish a connection to SQL Server.
> I would recommend taking a look to all your services and other automated
> tasks in the Windows 2003 machine and try to find out which one is the one
> trying to connect to SQL Server.
> -Raul Garcia
> SDE/T
> SQL Server Engine
> ________________________________________
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> "ola.martins@.gmail.com" wrote:
>|||If the windows 2003 server is running ARCserve and pointing to your database
try this;
Change your ARCserve Backup to use SQL authentication. I'm guessing from
your error that you are using Windows Authentication, is this correct.
Run Setupsql.exe from your CA install directory.
Good luck,
Carl
"ola.martins@.gmail.com" wrote:

> Hi,
> I posted this in the server-group, but no response, I removed the
> message and now trying with this group...
> I installed a SQL Server 2005 Workgroup on a W2k server.
> Every 20 second the SQL errorlog log the two lines below:
> DateTime Logon Error: 18456, Severity: 14, State: 11.
> DateTime Logon Login failed for user 'DOMAIN\SERVERNAME$'. [CLIENT:
> x.x.x.x]
> The x.x.x.x is the server's IP.
> State 11 means that the login doesn't have access to the server.
> Yah...? So...?
> The strange thing is that the "user" in this case is my 2003-server
> (note the dollar-sign).
> Could anyone point me in any direction - I am very lost.
> ( - and yes, the errorlog-file is now reaching 20MB after 2 weeks of
> headless logging...)
> Tanx in advance.
> /o
>

error(2)

create #table(A nvarchar(30), B nvarchar(20), c
nvarchar(15), D int)
insert into #table
select a,b,c,d
from x,y,z where c like 'Norm%'
group by a,b,c,d

create #table(class,name, exam,score) as:
A name1 math 100
A name1 math 88
A name1 Phy 98
A name1 Chm 98
A name1 SPT 89
A name2 math 54
A name2 math 79
A name2 Phy 79
A name2 Chm 44
A name2 SPT 34
B name1 math 54
B name1 math 23
B name1 Phy 54
B name1 Chm 98
B name1 SPT 89
B name2 math 35
B name2 math 35
B name2 Phy 33
B name2 Chm 66
B name2 SPT 12

Finding max(score) for exam started with 'm'
grouped by class and name.

select *,
(select max(result) from #table T where T.class =
D.class and
T.name = D.name and T.exame like 'm%' ) as mx

from #table D
DROP TABLE #table
GO

NOw, if there is no data inserted into #table , got:
not supported error message otherwise it works OK.
Do not like to get this error message when no data
is inserted into #table. how?.

If exists(select *,
(select max(result) from #table T where T.class =
D.class and
T.name = D.name and T.exame like 'm%' ) as mx
from #table D)

Did not resolve it.

--
Sent by from yahoo subdomain of com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.comu359375000@.spawnkill.ip-mobilphone.net (alexsql2000@.yahoo.com) wrote in message news:<l.1066087533.1806060791@.[63.127.215.130]>...
> create #table(A nvarchar(30), B nvarchar(20), c
> nvarchar(15), D int)
> insert into #table
> select a,b,c,d
> from x,y,z where c like 'Norm%'
> group by a,b,c,d
>
> create #table(class,name, exam,score) as:
> A name1 math 100
> A name1 math 88
> A name1 Phy 98
> A name1 Chm 98
> A name1 SPT 89
> A name2 math 54
> A name2 math 79
> A name2 Phy 79
> A name2 Chm 44
> A name2 SPT 34
> B name1 math 54
> B name1 math 23
> B name1 Phy 54
> B name1 Chm 98
> B name1 SPT 89
> B name2 math 35
> B name2 math 35
> B name2 Phy 33
> B name2 Chm 66
> B name2 SPT 12
> Finding max(score) for exam started with 'm'
> grouped by class and name.
> select *,
> (select max(result) from #table T where T.class =
> D.class and
> T.name = D.name and T.exame like 'm%' ) as mx
> from #table D
> DROP TABLE #table
> GO
>
> NOw, if there is no data inserted into #table , got:
> not supported error message otherwise it works OK.
> Do not like to get this error message when no data
> is inserted into #table. how?.
> If exists(select *,
> (select max(result) from #table T where T.class =
> D.class and
> T.name = D.name and T.exame like 'm%' ) as mx
> from #table D)
> Did not resolve it.

Your explanation isn't completely clear (your query doesn't match your
column names, and you don't give the exact error message you're
getting), but it looks like this should simply work:

select class, name, exam, max(score)
from #table
where exam like 'm%'
group by class, name, exam

If this isn't what you need, then consider posting working CREATE
TABLE statements, along with INSERTs to add your sample data, and the
output you expect.

Simon|||Hi

The following are untested by you may want to try:

If exists(select * from #table T where T.exame like 'm%' )
select *, (select max(T.result)
from #table T
where T.class = D.class
and T.name = D.name
and exame like 'm%' ) as mx
from #table D

Or try the following without the check:
select D.*, T.Mx
from #table D JOIN

(select Class, Name, max(result) as MX
from #table
WHERE exame like 'm%'
GROUP BY Class, Name ) T ON T.class = D.class
and T.name = D.name
WHERE D.exame like 'm%'

John

"alexsql2000@.yahoo.com" <u359375000@.spawnkill.ip-mobilphone.net> wrote in
message news:l.1066087533.1806060791@.[63.127.215.130]...
> create #table(A nvarchar(30), B nvarchar(20), c
> nvarchar(15), D int)
> insert into #table
> select a,b,c,d
> from x,y,z where c like 'Norm%'
> group by a,b,c,d
>
> create #table(class,name, exam,score) as:
> A name1 math 100
> A name1 math 88
> A name1 Phy 98
> A name1 Chm 98
> A name1 SPT 89
> A name2 math 54
> A name2 math 79
> A name2 Phy 79
> A name2 Chm 44
> A name2 SPT 34
> B name1 math 54
> B name1 math 23
> B name1 Phy 54
> B name1 Chm 98
> B name1 SPT 89
> B name2 math 35
> B name2 math 35
> B name2 Phy 33
> B name2 Chm 66
> B name2 SPT 12
> Finding max(score) for exam started with 'm'
> grouped by class and name.
> select *,
> (select max(result) from #table T where T.class =
> D.class and
> T.name = D.name and T.exame like 'm%' ) as mx
> from #table D
> DROP TABLE #table
> GO
>
> NOw, if there is no data inserted into #table , got:
> not supported error message otherwise it works OK.
> Do not like to get this error message when no data
> is inserted into #table. how?.
> If exists(select *,
> (select max(result) from #table T where T.class =
> D.class and
> T.name = D.name and T.exame like 'm%' ) as mx
> from #table D)
> Did not resolve it.
>
>
> --
> Sent by from yahoo subdomain of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com

Error While Exporting to Excel

Hi Group,
When i tried to export my report to excel it throws me this error
Error: Index was out of range.Must be non-negative and less than the size of
the collection.Parameter name:index.
My Report contains subreport in one column.I Placed my subreport in
rectangle tool
and placed the rectangle in the table cell.
can any only help me how to resolve this error.In excel renderer, subreport and data regions inside table / matrix cells
are not supported.
Anyway, you should be able to render the report with a nice error message in
place of subreport. Could you send us the report, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> Hi Group,
> When i tried to export my report to excel it throws me this error
> Error: Index was out of range.Must be non-negative and less than the size
of
> the collection.Parameter name:index.
> My Report contains subreport in one column.I Placed my subreport in
> rectangle tool
> and placed the rectangle in the table cell.
> can any only help me how to resolve this error.|||Hi Cristache,
In my Previous Discussion with CHRIS HAYS he Said
Subreports are not currently supported inside tables/matrixes in the Excel
renderer.
You could either convert your table to nested lists (this approach won't
work for matrix) or you could place the contents of your subreport into a
rectangle in the table/matrix cell. Note: This second approach involves
rewriting your query to join the main query data with the subreport query
data.
Now My Problem is I am not able to render the report to xls.But i have
another report with same concept and able to render to xls and values are
displaing in subreport column.But the other report what i was taking is
giving this error
Error: Index was out of range.Must be non-negative and less than the size of
the collection.Parameter name:index. And report is not rendering.
So how do i send the report to you.
"Nico Cristache [MSFT]" wrote:
> In excel renderer, subreport and data regions inside table / matrix cells
> are not supported.
> Anyway, you should be able to render the report with a nice error message in
> place of subreport. Could you send us the report, please?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
> message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> > Hi Group,
> >
> > When i tried to export my report to excel it throws me this error
> > Error: Index was out of range.Must be non-negative and less than the size
> of
> > the collection.Parameter name:index.
> >
> > My Report contains subreport in one column.I Placed my subreport in
> > rectangle tool
> > and placed the rectangle in the table cell.
> >
> > can any only help me how to resolve this error.
>
>|||I have the same error message
In my report I use 9 tables
all the rendering goes ok, but when I export it to excell I get the message
"Nico Cristache [MSFT]" wrote:
> In excel renderer, subreport and data regions inside table / matrix cells
> are not supported.
> Anyway, you should be able to render the report with a nice error message in
> place of subreport. Could you send us the report, please?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
> message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> > Hi Group,
> >
> > When i tried to export my report to excel it throws me this error
> > Error: Index was out of range.Must be non-negative and less than the size
> of
> > the collection.Parameter name:index.
> >
> > My Report contains subreport in one column.I Placed my subreport in
> > rectangle tool
> > and placed the rectangle in the table cell.
> >
> > can any only help me how to resolve this error.
>
>

Error while executing the Best Practice Group

Hi,
I've tried to install the BPA on two different SQL servers, but in every
case I get the following error executing it (bellow). I've reinstalled
several times and used different computers and SQL's. The .NET framework is
1.1. Any ideas?
"Error while executing the Best Practice Group. See the log file
Cmpl_javierx_0001_1.1.1.1_sqlbpa.log. Error message: Execution log not found
in the repository"
Thanks
Any ideas? Anyone?
"Javier" wrote:

> Hi,
> I've tried to install the BPA on two different SQL servers, but in every
> case I get the following error executing it (bellow). I've reinstalled
> several times and used different computers and SQL's. The .NET framework is
> 1.1. Any ideas?
> "Error while executing the Best Practice Group. See the log file
> Cmpl_javierx_0001_1.1.1.1_sqlbpa.log. Error message: Execution log not found
> in the repository"
> Thanks
>
>
|||Hi Javier,
If you didn't find your solution yet, I've got the same problem as you
but fix it by unchecking the no Count option on in the SQL Server Properties.
In the connection Tab, you will need to uncheck "no Count"... Try that, it
should fix the problem...
"Javier Limones" wrote:
[vbcol=seagreen]
> Any ideas? Anyone?
> "Javier" wrote:
|||Dennis,
Sorry for the late reply... The servers we use need the "No Count" option
checked for an application to work... Is there another way to fix this?
Javier
"Denis Daigle" wrote:
[vbcol=seagreen]
> Hi Javier,
> If you didn't find your solution yet, I've got the same problem as you
> but fix it by unchecking the no Count option on in the SQL Server Properties.
> In the connection Tab, you will need to uncheck "no Count"... Try that, it
> should fix the problem...
> "Javier Limones" wrote: