We are running server 2008 and have and instance of SQL express 2005 on it. I am receiving this error below.
Log Name: Application
Source: SQLWRITER
Date: 8/4/2015 7:40:49 AM
Event ID: 24583
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Colstorage.Lauderhill.net
Description:
Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 42000, Native Error: 18470
Error state: 1, Severity: 14
Source: Microsoft SQL Server Native Client 10.0
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: The account is disabled.
DBPROP_INIT_DATASOURCE: COLSTORAGE\MOTOROLARMSERVER
DBPROP_INIT_CATALOG: master
DBPROP_AUTH_INTEGRATED: SSPI
What about these from the error above? Will running the command above fix these items below?
DBPROP_INIT_DATASOURCE: COLSTORAGE\MOTOROLARMSERVER
DBPROP_AUTH_INTEGRATED: SSPI
Deepak Chauhan
DBPROP_INIT_DATASOURCE: COLSTORAGE\MOTOROLARMSERVER ---- This is server name.
DBPROP_AUTH_INTEGRATED: SSPI --- This is authentication type (Windows Authentication here)
error is saying
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: The account is disabled.
The command above is for enable this account. This should be resolved by executing the command.
Connect to SQL Server When System Administrators Are Locked Out
https://msdn.microsoft.com/en-us/library/dd207004.aspx