error when i start the sql server agent

[papaboy2]

how can i fix the problem when i try to start the sql server agent an error occurs, but the sql distributed transaction is ok when i click the start button. i installed the sql server 7.0 on my windows xp pro pc. i tried registering my pc in enterprise manager using win nt authentication and the SQL Logon using "sa" and blank password but i can't connect,?please help!, thank you very much!

 

[SonOfEmidec1100]

If you want to use 'sa' to connect then you need to use the SQL Server and Windows authentication option.

See Server Properties/Security/Authentication.

 

[SQLBill]

What error are you getting? Check the SQL Server Error Logs and the Windows Event Viewer logs for any related error messages.

What version of SQL Server 7 do you have installed?

As SoE1100 says, you need to have your server set to mixed mode authentication (SQL Server and Windows) if you are going to use the SA account.

What login does the SQL Server services (MSSQLServer and SQLServerAgent) use? (Right click on the My Computer icon, select Manage, expand Services and look for those services).

If you are only using SQL Server on your local computer and aren't accessing any network files, the login LOCAL ADMIN is good enough for the services. If you are accessing network files, the account needs to be a domain account with access to those files.

Lastly, give the SA account a strong password. Every hacker knows that SQL Server is shipped with the SA account having a blank password. They also know that the SA account is the 'GOD' account.

-SQLBill

 

[craigfw]

Having the same problem. Running MS Windows 2003 Server and the SQL Server Agent Error Log is saying:

[298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000]

and

[000] Unable to connect to server '(local)'; SQLServerAgent cannot start.

I'm not the boxes Admin, but I have Admin privliges, I also didn't install the SQL Server, but came into this position after the fact.
I have logged onto the Windows 2003 as myself and have granted permissions "wide open" on the directory properties and the folders below.

Any other ideas, I could be chasing shadows?

 

[mrdenny]

It looks like the Agent is running under the local system account, and someone has removed the local systems access to log into the database. Set the sql agent to run under a domain account and grant that account access to the database.

Denny

--Anything is possible. All it takes is a little research. (Me)