May 10, 2010 at 10:49 am
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
May 10, 2010 at 12:13 pm
B'coz your login doesn't have permissions.
http://www.sqlservercentral.com/Forums/Topic536293-146-1.aspx#bm912541
Whats the edition of sql server?
May 10, 2010 at 12:59 pm
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!
May 10, 2010 at 1:15 pm
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'
May 10, 2010 at 1:33 pm
Hello,
Sweet, this is exactly what I was looking for.
Thanks!
May 10, 2010 at 1:44 pm
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
May 10, 2010 at 1:52 pm
You won't be able to see it until that statement is executed.
May 10, 2010 at 2:37 pm
Great, thanks so much for you help!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply