I can't start the SQL Agent in an MSDE installation. It stops right away.
The Error log says :
<<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).>>

Both the Agent and the SQL server instance were set up to have the same
Service Startup accounts (I think - not having any client tools on the
machine makes it difficult to check). I can only connect remotely to the
machine.

What can I use on the Command line interface to fix this issue?
Thanks for the help.
Jav

Make sure that you add to the the user that is running the sql and
sqlServerAgent services to the sysadmin role .

You can get it done by running

Exec sp_grantlogin Computername\Username
go
Exec sp_addsrvrolemember @loginname=computername\Username, @rolename=sysadmin


JFR



"Jav" wrote: