Saturday, February 25, 2012

Cannot start sql agent in 2005

I get this message when I try to start a sql 2005 server agent. Im
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Agent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and that it has sysadmin
privileges in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>

No comments:

Post a Comment