Wednesday, March 21, 2012

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
>

No comments:

Post a Comment