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. 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

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SQLWRITER" />
<EventID Qualifiers="0">24583</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2015-08-04T11:40:49.000000000Z" />
<EventRecordID>44343</EventRecordID>
<Channel>Application</Channel>
<Computer>Colstorage.Lauderhill.net</Computer>
<Security />
</System>
<EventData>
<Data>IDBInitialize::Initialize</Data>
<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\MOTOROLARMSERVER
DBPROP_INIT_CATALOG: master
DBPROP_AUTH_INTEGRATED: SSPI
</Data>
<Binary>53514C434F4E4E43373130000000000053514C434F4E4E433436370000000000</Binary>
</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

plusone3055

here are the steps to resolve :)

Connect to SQL Server When System Administrators Are Locked Out
https://msdn.microsoft.com/en-us/library/dd207004.aspx

Deepak Chauhan

Connect sql server using SSMS and execute below command

use master
go
alter login [NT AUTHORITY\SYSTEM] enable

colmisdiv

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

Deepak Chauhan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

colmisdiv

ASKER

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.