Friday, March 02, 2012 6:38 PMuser is in sqlagentoperatior,reader and userrole, but cannot see agent in ssms.
Friday, March 02, 2012 7:01 PM
Those permissions should be sufficient, have you tried refresh the ssms view.
One note is that if you are using Express edition then there is no agent available.
Friday, March 02, 2012 7:57 PM
thanks, did refresh,
use STD version SSMS
Sunday, March 04, 2012 9:05 AMModerator
Tuesday, March 06, 2012 8:12 AMModerator
To use SQL Server Agent, users must be a member of one or more of the following fixed database roles:
These roles are stored in the msdb database. By default, no user is a member of these database roles. Membership in these roles must be granted explicitly. Users who are members of the sysadmin fixed server role have full access to SQL Server Agent, and do not need to be a member of these fixed database roles to use SQL Server Agent. If a user is not a member of one of these database roles or of the sysadmin role, the SQL Server Agent node is not available to them when they connect to SQL Server by using SQL Server Management Studio.
You could try to restart SQL Server Management Studio to see if it will work.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Wednesday, March 14, 2012 2:48 PM