Avatar of colmisdiv
colmisdiv
 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
Microsoft SQL Server 2005Windows Server 2008

Avatar of undefined
Last Comment
Deepak Chauhan

8/22/2022 - Mon
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Deepak Chauhan

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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.