Can''t start the SQLAGENT

Question

Post reply

Can''t start the SQLAGENT

Attopeu

Ten Centuries

Points: 1308
More actions
May 10, 2006 at 10:31 am

#117551
Hi Guru,
I'm sick of trouleshoot one of my sql box that the sqlagent can't started. Here is the message:
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start)
- SQLSERVER runs on LocalSystem account with started up type automatic and successful
- Connect to SQL Analyzer: LocalHost, . (period), (local) and blank all successful
- Registry key and MDAC are good safe
- BUILTIN\Administrators is present and SYSADMIN rights
- From AD, domain accounts passwords are in synch.
- Win2000, SQL2000 SP3a and build 800.00.760
- Client and network utility used both name pipe and TCP
From enterprise manager on the server itself, I am able to register the server by supplying the server name. However, when I tried to register with the (local), I was never able to do so.

I also tried to restart the SQL agent with localsystem, domain and local admin accounts none of them can start the service. These accounts are local admin to the box and have complete sysdmin rights to sql server. From query analyzer, these accounts can connect to server with blank, LocalHost, (local), and period. So, this tells me that the server does not experience of resolving (local) connection.

I tried to log on to the server with both local and domain accounts to start agent but nothing is good for me. I tried to change startup account from enterprise manager to make sure security is in synch but still the same.

However, the last thing that I’ve not done is reboot the OS.

Please help,

Thanks,
Silaphet,

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sqldba-294117 Hall of Fame Points: 3486 More actions · Answer 1

Couple of things need to check.

1> make sure SQL SERVER Services & Agents runs under Domain Account.

2> Exit out Service Manager & start again from Start--Proram....

3> BUILTIN\Administrators account is there in SQL Server. check to see if The BUILTIN\Administrators login does not have access to sql server or the BUILTIN\Administrators login has been removed. I don't know if access is removed for BUILTIN\Administrators. this also cause your agent not to run.

4> if you have recently installed SP-4, then re-install again.

5> Check the services & see how SQL Agent account is configure, as it may have changed or some body might have changed.

6> disabling your anti-virus for testing purpose.

7> Check the following registry key.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server\Driver

It should be pointing to c:\[Windows folder]\system32\SQLSRV32.dll

8> you may have a problem resolving Localhost or (local) or . (that's a period, btw). You might want to check for rogue DSN's (Administrative Tools, DataSource Administrator). Check System and User DSN's.

I hope this will help.

sqldba-294117 Hall of Fame Points: 3486 More actions · Answer 2

http://support.microsoft.com/?scid=kb;en-us;237604&spid=2852&sid=global

GARCIA SSC Enthusiast Points: 111 More actions · Answer 3

Hi, we have a similar problem under windows 2000 sp4 with SQL Server standard sp4 onto a muti processor server.

The problem was due to a server option under processor tab -> "Use NT Fiber". After unchecking this option and restarting SQL Server, SQL Server agent start correctly.

Hope it will help you.

Fred.

Attopeu Ten Centuries Points: 1308 More actions · Answer 4

Fred,

We never ever touched server configurations. The server runs on thread mode not fiber mode. The NT Fiber option is unchecked. I don't think this is the case.

Any ideas?

Thanks,

Silaphet,

Rao.V Hall of Fame Points: 3452 More actions · Answer 5

Nothing mentioned above helped. still agent is in stopped state. 🙁