x

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.

more ▼

asked Jun 02 '10 at 12:30 PM in Default

Katie 1 gravatar image

Katie 1
1.4k 129 163 202

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jun 02 '10 at 01:25 PM

Oleg gravatar image

Oleg
15.9k 2 4 24

But Oleg, This is the SA. Does the login with SA needs this?
Jun 02 '10 at 01:47 PM Katie 1
@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
Jun 02 '10 at 02:59 PM Oleg
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x86
x85

asked: Jun 02 '10 at 12:30 PM

Seen: 3334 times

Last Updated: Jun 02 '10 at 12:30 PM