Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
10Dawg
Starting Member
46 Posts |
 Posted - 2013-07-16 : 14:38:11
|
| One of my logins can not see the sql server agent in his left-hand tree. What controls this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
10Dawg
Starting Member
46 Posts |
Posted - 2013-07-16 : 14:57:51
|
| we have 2 sql servers and he accesses both from his desktop. One one instance, he can see (and access) the job agent. He can not see it on the other instance. I have given him the exact same rights to both. Sorry I did not go into more detail initially.10Dawg |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-16 : 15:44:57
|
| THe question Tara wsa asking is whether both the servers are non-express editions (and whether they have SQL Agent installed). If they do have SQL Agents, and your user cannot see one and can see the other, it is an issue relating to permissions. See here for permissions required: http://msdn.microsoft.com/en-us/library/ms188283.aspx |
|
|
|
10Dawg
Starting Member
46 Posts |
Posted - 2013-07-16 : 16:05:02
|
| i figured it out. He had not logged out/in since I gave him sysadmin rights. Thanks to all.10Dawg |
|
|
|
|
|
|
Can not see SQL Server Agent