Error: 18456 Severity: 14 State:11

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ola.martins@gmail.com - 04 Jul 2006 09:01 GMT

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

Reply to this Message

Raul Garcia [MS] - 07 Jul 2006 01:25 GMT

It 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
________________________________________

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi,
> I posted this in the server-group, but no response, I removed the
[quoted text clipped - 23 lines]
> Tanx in advance.
> /o

Reply to this Message

ola.martins@gmail.com - 07 Jul 2006 14:39 GMT

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:

> It seems like some service on your Win 2003 machine is trying to connect to
> the SQL Server instance on the Windows 2000 one.
[quoted text clipped - 40 lines]
> > Tanx in advance.
> > /o

Reply to this Message

Carl Weiss - 29 Aug 2006 20:19 GMT

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

> Hi,
> I posted this in the server-group, but no response, I removed the
[quoted text clipped - 23 lines]
> Tanx in advance.
> /o

Reply to this Message