asked on
SQl 2005 express issue
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.
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\MOTOROLARMSERVE
DBPROP_INIT_CATALOG: master
DBPROP_AUTH_INTEGRATED: SSPI
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SQLWRITER" />
<EventID Qualifiers="0">24583</Even
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2015-08-04T11:
<EventRecordID>44343</Even
<Channel>Application</Chan
<Computer>Colstorage.Laude
<Security />
</System>
<EventData>
<Data>IDBInitialize::Initi
<Data>0x80004005</Data>
<Data>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\MOTOROLARMSERVE
DBPROP_INIT_CATALOG: master
DBPROP_AUTH_INTEGRATED: SSPI
</Data>
<Binary>53514C434F4E4E4337
</EventData>
</Event>
Screen shot attached. The sql agent that is disabled is supposed to be per the software vendor.C--Users-jburka-Desktop-Doc11.docx
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.
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\MOTOROLARMSERVE
DBPROP_INIT_CATALOG: master
DBPROP_AUTH_INTEGRATED: SSPI
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SQLWRITER" />
<EventID Qualifiers="0">24583</Even
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2015-08-04T11:
<EventRecordID>44343</Even
<Channel>Application</Chan
<Computer>Colstorage.Laude
<Security />
</System>
<EventData>
<Data>IDBInitialize::Initi
<Data>0x80004005</Data>
<Data>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\MOTOROLARMSERVE
DBPROP_INIT_CATALOG: master
DBPROP_AUTH_INTEGRATED: SSPI
</Data>
<Binary>53514C434F4E4E4337
</EventData>
</Event>
Screen shot attached. The sql agent that is disabled is supposed to be per the software vendor.C--Users-jburka-Desktop-Doc11.docx
Microsoft SQL Server 2005Windows Server 2008
Last Comment
Deepak Chauhan
Connect sql server using SSMS and execute below command
use master
go
alter login [NT AUTHORITY\SYSTEM] enable
use master
go
alter login [NT AUTHORITY\SYSTEM] enable
ASKER
The only thing installed is the sql server configuration mgr. This is the express version of 2008 R2 not 2005 as stated above.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
What about these from the error above? Will running the command above fix these items below?
DBPROP_INIT_DATASOURCE: COLSTORAGE\MOTOROLARMSERVE
DBPROP_AUTH_INTEGRATED: SSPI
DBPROP_INIT_DATASOURCE: COLSTORAGE\MOTOROLARMSERVE
DBPROP_AUTH_INTEGRATED: SSPI
DBPROP_INIT_DATASOURCE: COLSTORAGE\MOTOROLARMSERVE
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.
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