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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migrated from Jan 3 '12 at 0:39

This question came from our site for professional and enthusiast programmers.

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

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
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


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