Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Canno see SQL Server Agent properties despite sysadmin permission Expand / Collapse
Author
Message
Posted Wednesday, May 14, 2008 9:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 27, 2012 1:56 AM
Points: 4, Visits: 80
I'm connecting to a SQL server 2000 (SP4) instance via a domain account that has sysadmin privileges but when I look at the properties for the SQL Server Agent the SQL Service Startup account is greyed out. Also the SQL Server Agent doesn't show as either stopped or started in Enterprise Manager. No problems if I logged on to the server directly.

Post #500586
Posted Monday, June 13, 2011 7:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:39 PM
Points: 229, Visits: 803
Did you ever get an answer to this? I have the same problem. Thanks. Patti
Post #1124266
Posted Monday, June 13, 2011 8:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 27, 2012 1:56 AM
Points: 4, Visits: 80
If I remember rightly it's down to whether or not you're an adminstrator on the server (as opposed to a member of the SQL sysadmin role).
Post #1124322
Posted Monday, June 13, 2011 8:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:39 PM
Points: 229, Visits: 803
When you say administrator on the server, do you mean member of local admin group? I know it's been a long time ago so thanks for replying.
Post #1124331
Posted Monday, June 13, 2011 9:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 27, 2012 1:56 AM
Points: 4, Visits: 80
Yep, member of the local admin group.

You're right, it was a long time ago and these days I often struggle to remember what I did yesterday
Post #1124337
Posted Monday, June 13, 2011 9:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:39 PM
Points: 229, Visits: 803
Thanks Paul. I'm with ya on the memory thing. Have a good day and thanks.
Post #1124340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse