Prev: Server: Msg 7105
Next: Error Msg
From: Rockitman on 17 May 2010 11:54
Just started happening. Can't understand why. It uses the local system
account to login but it can't login. Event Viewer application log states:

"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"


Can anybody help?
From: John Bell on 17 May 2010 17:26
On Mon, 17 May 2010 08:54:01 -0700, Rockitman
<Rockitman(a)discussions.microsoft.com> wrote:

>Just started happening. Can't understand why. It uses the local system
>account to login but it can't login. Event Viewer application log states:
>
>"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"
>
>
>Can anybody help?


Does this help?
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/e719a270-b802-466a-9839-455171197b7c/

Try changing the service account to a domain account and see if it
works. Then try changing it back.

John
 | 
Pages: 1
Prev: Server: Msg 7105
Next: Error Msg