TITLE: Microsoft SQL Server Management StudioGuys, 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: OKThanks.
(comments are locked)
|
|
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: The login name should be typed without the single quotes. 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)
|
