Showing posts with label native. Show all posts
Showing posts with label native. Show all posts

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

Wednesday, March 21, 2012

errors... lots of errors.

Good Morning...
Any thoughts...
Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite
(WrapperWrite()).Native error: 4 SQLState: 01000}{[Microsoft][O
DBC 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.
Markussql