Unable to view SQL Server Agent while logged in as user

  • Hi All,

    I have granted SQLAgentUserRole permission to one of the user and using enterprise edition of SSMS. still user is not able to view SQL Server Agent when he is logged in SSMS. Any help will be greatly appriciated.

    Regards,

    KJ.

  • kumarjohnt (10/15/2014)


    Hi All,

    I have granted SQLAgentUserRole permission to one of the user and using enterprise edition of SSMS. still user is not able to view SQL Server Agent when he is logged in SSMS. Any help will be greatly appriciated.

    Regards,

    KJ.

    Should be able to see. Please check the login and user once again.

  • I have checked with user again. Still he is not able to see.

  • Is the user using SSMS Express? If so the Agent won't be visible and you'll need to install the full version of SSMS instead.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply