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 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy