Prev: Error Msg
Next: How to view a list of values in a single field
From: Erland Sommarskog on 17 May 2010 17:26
Rockitman (Rockitman(a)discussions.microsoft.com) writes:
> 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"

I would guess that someone has dropped the login BUILTIN\Adminstraots,
or removed it from the sysadmin server role. Could this be the case?


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Error Msg
Next: How to view a list of values in a single field