SQL Server 2008 ERRORSTATE 28000

[manguilla]

Hello. I'm having an issue with the SQL Server Agent service not starting. I am getting the following messages listed below:

[098] SQLServerAgent terminated (normally)
[382] Long to server 'XXXXXXXXX' failed (DisableAgentXPs)
[298] SQLServer Error: 18456, Login failed for user 'xxxxx' [SQLSTATE 28000]
[000] SQLServerAgent cannot start
[298] ...same as above...

From my research online this error appears to only happen in previous versions so I can't find a solution. I am running SQL Server 2008 Standard on Windows XP SP3. Is there a logon I'm missing? Is it a permissions thing? Any help would be appreciated. Thanks.



manguilla

 

[gmmastros]

Just a guess, but try this...

Click Start -> Run
Type services.msc
Click OK
Scroll down to "SQL Server Agent"
Right Click -> Properties
Click the "Log On" tab.

If you are NOT using "Local System Account", then you need to have a valid windows account (and password). If you choose to use a windows account (instead of Local System Account), it's usually best to create an account specifically for SQL Server. This way, you can give it a super strong password and set the password to never expire.

Like I said, this is just a guess, but it's where I would look first.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[manguilla]

Yes I am using a windows account that was put in by default. It's the same user that is listed under the SQL Server service. The user is listed below. If I remove NETWORK SERVICE what password does SQL Server use by default for this user in case I need to put it back? Thanks.

NT AUTHORITY\NETWORK SERVICE



manguilla