Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I have installed full setup of SQL Server, and start the service for SQL Agent through SQL Server surface area. But still I can't get SQL Agent tree node in my SQL Server connection treeview.

So please help me what I have to do for getting SQL Agent in treeview.

share|improve this question
1  
Do you have the permissions to see it? SSMS lets me connect to the database see the tree; but unless the DBA granted me privileges, I couldn't see it either. – xQbert Jan 2 '12 at 14:29

migrated from stackoverflow.com Jan 3 '12 at 0:39

1 Answer

up vote 1 down vote

Minimum rights needed to see the agent node you need to have sysadmin rights on the instance or rights to the agent database roles in msdb.

share|improve this answer
And an edition above Express – gbn Jan 3 '12 at 8:09
1  
Thought about that, but he said he got the agent started, and the SQLEXPRESS agent instance defaults to disabled and doesn't start properly if you try to change the type. – Jason Cumberland Jan 3 '12 at 13:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.