[SOLUTION] SQl 2005 express issue

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

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 22

plusone3055Commented: 2015-08-04

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

LVL 16

Deepak ChauhanSQL Server DBACommented: 2015-08-04

Connect sql server using SSMS and execute below command

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

colmisdivAuthor Commented: 2015-08-05

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

Deepak ChauhanSQL Server DBACommented: 2015-08-05

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"

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

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

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.

SQl 2005 express issue

Who is Participating?