SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Can not see SQL Server Agent
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

10Dawg
Starting Member

USA
46 Posts

Posted - 07/16/2013 :  14:38:11  Show Profile  Reply with Quote
One of my logins can not see the sql server agent in his left-hand tree. What controls this?

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 07/16/2013 :  14:52:53  Show Profile  Visit tkizer's Homepage  Reply with Quote
Sounds like he has SQL Server Express tools installed. Have him install a non-Express version.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

10Dawg
Starting Member

USA
46 Posts

Posted - 07/16/2013 :  14:57:51  Show Profile  Reply with Quote
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
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3653 Posts

Posted - 07/16/2013 :  15:44:57  Show Profile  Reply with Quote
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
Go to Top of Page

10Dawg
Starting Member

USA
46 Posts

Posted - 07/16/2013 :  16:05:02  Show Profile  Reply with Quote
i figured it out. He had not logged out/in since I gave him sysadmin rights. Thanks to all.

10Dawg
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000