question

Katie 1 avatar image
Katie 1 asked

SQL SERVER AGENT ERROR

TITLE: Microsoft SQL Server Management Studio

Guys,

this is the error when i am actually trying to use the job activity monitor in SSMS. I wonder why is this coming?

======================================================================================

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Unable to execute requested command.

jobs (SqlManagerUI)

BUTTONS:

OK

Thanks.

sql-server-2008sql-agentjob
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Oleg avatar image
Oleg answered

SSMS will allow the login to view Job Activity Monitor dialog only if the login has vew server state permission set. here is the syntax to grant this permission:

grant view server state to your_login_name

The login name should be typed without the single quotes.

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Katie 1 avatar image Katie 1 commented ·
But Oleg, This is the SA. Does the login with SA needs this?
0 Likes 0 ·
Oleg avatar image Oleg commented ·
@Katie: Sorry, I did not realize that you connect as SA who does not need this permission set. Another source of this problem could be installing SSMS 2008 Express and installing only "Basic Tools". There is a short post on main SSC site suggesting to install SP1: http://www.sqlservercentral.com/Forums/Topic885701-391-1.aspx
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.