SQl 2005 express issue

colmisdiv
colmisdiv used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
plusone3055

Commented:
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 ChauhanSQL Server DBA

Commented:
Connect sql server using SSMS and execute below command

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

Author

Commented:
The only thing installed is the sql server configuration mgr. This is the express version of 2008 R2 not 2005 as stated above.
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Start Today!
SQL Server DBA
Commented:
In this case you can download SQL server management studio, this is freely available from Microsoft.

Or you can use SQLCMD to execute this command.

Open Windows CMD and call sqlcmd

SQLCMD -S < servername> -E -d "master" -Q "alter login [NT AUTHORITY\SYSTEM] enable"
colmisdiv

Author

Commented:
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 ChauhanSQL Server DBA

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial