Thursday, March 22, 2012

errors... lots of errors.

Good Morning...
Any thoughts...
Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite
(WrapperWrite()).Native error: 4 SQLState: 01000}{[Microsoft][ODBC SQL
Server Driver][Shared Memory]General network error. Check your network
documentation.Native error: 11 SQLState: 08S01}
The following information is part of the event:
IDBInitialize::Initialize, 0x80040e4d, SQLSTATE: 42000, Native Error:
18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.
Help and Support for details. The following information is part of the
event: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'.
The following information is part of the event:
IDBInitialize::Initialize, 0x80040e4d, SQLSTATE: 42000, Native Error:
18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.
.Heather,
If I had to take a gues I would say someone has removed the build-in
Administrators group from SQL Server without adding a Login for the
local system account. Now the server tries to start, but because the
login doen't exist anymore you get these errors. Change the service
logon account to a domain account which has administrative access to
SQL Server and you should be able to start the server again.
Markus

No comments:

Post a Comment