Re: Unable to see SQL Server Agent Node - what permissions do I need?

Jan,

You need access to one of the SQLAgentxxxRole(s) in msdb.

There are 3 SQLAgentxxxRole(s) that have different levels of permission. See
BOL for more details.

Chris

"Jan Leste" <user@xxxxxxxxxxx> wrote in message
news:el6kIjhHHHA.3268@xxxxxxxxxxxxxxxxxxxxxxx
I am a newbie to SQL 2005 and trying to understand the permissions. When I
run SQL Management Studio with an account that is not a local admin on the
remote SQL Server, I can't see the SQL Agent node at all. What permissions
do I need to set in SQL so that I can see that node.

Thanks


.

Relevant Pages

  • Re: Unable to see SQL Server Agent Node - what permissions do I need?
    ... There are 3 SQLAgentxxxRolethat have different levels of permission. ... See BOL for more details. ... run SQL Management Studio with an account that is not a local admin on the remote SQL Server, I can't see the SQL Agent node at all. ...
    (microsoft.public.sqlserver.security)
  • Re: Complete Neophyte Question(s)
    ... You should not have to go Google to find out what WITH GRANT means. ... Server comes with online documentation on you hard disk. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ...
    (microsoft.public.sqlserver.security)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.sqlserver.msde)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.adonet)