Cannot start agent...

Hi there.
I am getting the following error when trying to start the Sqlserver agent
(on a version 7 db):
SQLServerAgent could not be started (reason: Unable to connect to server;
SQLServerAgent cannot start).
I have connect to the server using the NT windows authentication (which is
what is used to start the agent) and I connect 100%.
Does anyone have any ideas?
Any help will be appreciated.
Thanks
ClintThe SQL Server MUST be running and a domain controller must be available...
SQL Agent MUST also connect to SQL with a SQL login which has ADMINISTRATIVE
SQL privelege..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>|||Clint,
Here is a link to an article by Richard Waymire on 7.0 security
http://tinyurl.com/j24t . It discusses security issues related to SQL Agent
The following Troubleshooting guide for SS2000 may also be of interest:
http://tinyurl.com/j249
Russell Fields
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>