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

SQL Server Agent not showing Expand / Collapse
Author
Message
Posted Monday, May 10, 2010 10:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 09, 2014 10:16 PM
Points: 265, Visits: 587
Hi all,

For some reason SQL Server Agent does not show in the object explorer window when I connect to a SQL 2005 server (from a client computer). Not sure why. Our DBAs aren't sure either. If I remote desktop into the server itself, I do see the SQL Server Agent.

Anyone know why this is happening?

Thanks,

James



Post #919171
Posted Monday, May 10, 2010 12:13 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, February 27, 2014 11:17 AM
Points: 1,688, Visits: 8,756
B'coz your login doesn't have permissions.

http://www.sqlservercentral.com/Forums/Topic536293-146-1.aspx#bm912541

Whats the edition of sql server?
Post #919227
Posted Monday, May 10, 2010 12:59 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 09, 2014 10:16 PM
Points: 265, Visits: 587
Hi,

Thanks for your response. We're using Enterprise edition. Do you know the steps we need to take to give permission to my login? I want to be able to speak intelligently to them (our DBAs) when I share how we'd go about doing it.

Thanks!



Post #919259
Posted Monday, May 10, 2010 1:15 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, February 27, 2014 11:17 AM
Points: 1,688, Visits: 8,756
Ask them to add your login to msdb database 'sqlagentuserrole' .

To add a user as a member of the 'sqlagentuserrole' , you can execute the following command:

use msdb

EXECUTE sp_addrolemember@rolename = 'sqlagentuserrole' ,@membername = 'username'
Post #919267
Posted Monday, May 10, 2010 1:33 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 09, 2014 10:16 PM
Points: 265, Visits: 587
Hello,

Sweet, this is exactly what I was looking for.

Thanks!



Post #919279
Posted Monday, May 10, 2010 1:44 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 09, 2014 10:16 PM
Points: 265, Visits: 587
Quick question,

I looked in the msdb database for the role 'sqlagentuserrole' and didn't see it (not sure if I can't see the role due to my rights) even though I could see many other roles in this database. If this role doesn't exist would they need to add the role as well (or does it always exist and I just can't see it due to rights) prior to running the previous statement?

Thanks



Post #919285
Posted Monday, May 10, 2010 1:52 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, February 27, 2014 11:17 AM
Points: 1,688, Visits: 8,756
You won't be able to see it until that statement is executed.
Post #919295
Posted Monday, May 10, 2010 2:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, February 09, 2014 10:16 PM
Points: 265, Visits: 587
Great, thanks so much for you help!


Post #919317
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse