Hello,

After upgrading to SQL 2008 ENT from SQL 2000 ENT SP4, the agent won't
start.

Here is the event log.


Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Service Control
Event ID: 103
Date: 10/2/2009
Time: 10:36:28 PM
User: N/A
Computer: xxx1
Description:
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).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


I have tried adding the accounts into the "Lock pages in memory" from the
local policy, but don't have any luck.

I read somewhere I have to run in query analyzer with the following procedure:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO


Where can I run this in sql 2008 (cannot locate query analyzer)?

TIA,
tnt

tnt (tnt (AT) discussions (DOT) microsoft.com) writes:
What is the service account for SQL Server Agent? It seems that this
account is not a member of the sysadmin role in SQL Server.

Query Analyzer (and Enterprise Manager) has been replaced by SQL Server
Mangement Studio in SQL 2008.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

tnt wrote:
http://eventid.net/display.asp?event...RAGENT&phase=1

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services
http://mypcassistant.blogspot.com/