Take the 2-minute tour ×
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.

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 stackoverflow.com Jan 3 '12 at 0:39

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

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

1 Answer 1

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.