Can't start the SQLAGENT

Hi Guru,

I'm tired 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,

.

Relevant Pages

  • Re: SQL MAIL and Sql Server Agent problem
    ... know how to prove that I am using the same account for SQL Server and SQL ... Is it a true statement that if the accounts are different I ... Exchange setup by just rebooting the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Maximum Number of Database Users and Roles
    ... > of security accounts for sql server is 16379 ... > originally setup using a Windows Domain Group and users to access our sql ... > server database. ... > How are you accessing your database using sql secrutiy accounts with> ...
    (microsoft.public.inetserver.asp.db)
  • Re: Server or Service Accounts complete lockdown?
    ... The devs should have had their own accounts. ... Individual accounts also assists in discovering the "who done it". ... If the access to the SQL databases by the IIS application is not done ... Microsoft MVP (Windows Server: Security) ...
    (microsoft.public.security)
  • Re: 2-node cluster wont stop sqlservr.exe during user-initiated f
    ... I'm concerned that the roaming profiles required for cluster access to ... the SQL service accounts MUST be ... > Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Account to Run SQL under?
    ... domain accounts) can be allocated email accounts so sql ... server can send emails, whereas local userid's cannot. ... >to restrict this access, but then we will be effected by ...
    (microsoft.public.sqlserver.server)
Loading