[dba-SQLServer] My Agent was assasinated!!

Followup, Server is Win2003 SP1, Sql Srv 2000 SP4.

When I pull up EM on the Server I get this error:
--------------------------------------------------------------------
A connection could not be established to (local)
Reason: SQL Server does not exist or access denied.
ConnectionOpen (Connect())

Please Verify SQL Server is running and check your SQL Server
registration properties (by right-clicking on the (local) node) and
try again.
--------------------------------------------------------------------
The SQLAgent.out file reads as follows:
---------------
2006-08-18 08:39:49 - ! [298] SQLServer Error: 17, SQL Server does not
exist or access denied. [SQLSTATE 08001]
2006-08-18 08:39:49 - ! [298] SQLServer Error: 1703, ConnectionOpen
(Connect()). [SQLSTATE 01000]
2006-08-18 08:39:49 - ! [000] Unable to connect to server '(local)';
SQLServerAgent cannot start
2006-08-18 08:39:50 - ? [098] SQLServerAgent terminated (normally)
----------------

question is how do I restore the connectivity on the server (to itself?)


On 8/18/06, Francisco Tapia <fhtapia at gmail.com> wrote:
> Helpdesk guy on an instruction from our sysadmin, was instructed to
> visit one of my sql servers and "UNINSTALL" BackupExec from the
> machine as we have moved to a central backup system.  After the
> install the server came up but he did not know to check in EM that the
> sql server was running and that the agent was running...
>
> ON the server you cannot use EM to see the (local) sql server status,
> remotely I can use EM and verified that the server is running, and all
> my users can access the server just fine.  What is not running is the
> Sql Server Agent.  And I am not able to restart it for some reason.
> Any advise would be very helpful.

-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...