user in sqlagentoperatorrole,readerrole and userrole, not able to sqlagent

Question

user is in sqlagentoperatior,reader and userrole, but cannot see agent in ssms.

Answer 1

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.

Answer 2

thanks, did refresh,

use STD version SSMS

Answer 3

The version of SSMS isn't tje issue here, it is the edition of the database engine. Do you see Agent if you login as somebody with, say, sysadmin priviliges (every thing else being equal, from the same client machine etc)?

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 4

Hi George,

To use SQL Server Agent, users must be a member of one or more of the following fixed database roles:
 
SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole

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.

Thanks,
Maggie

---

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.