“Cannot show requested dialog” when using SQL Server 2008 Job Activity Monitor

A colleague discovered this one last week.

In SQL Server 2008, if you try and launch the job activity monitor, you may get the message

“Cannot show requested dialog.

Additional Information:

Unable to execute requested command. jobs (SqlManagerUI)”

Microsoft (http://connect.microsoft.com/SQLServer/feedback/details/354939/cannot-open-dialog-in-job-activity-monitor & http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/f71d42f8-4045-4531-b3f9-bf7949222c68/) have confirmed that this is by design if you choose to install the basic SQL Server Management Suite (aka SSMS) tools during installation.

We reran the installation and chose the advanced tools option and the Job Activity Monitor worked fine.

According to other users (http://www.xantha.org/blog/?p=326), installing Visual Studio 2010 (aka VS2010) after SQL Server 2008 can revert to basic tools also, resulting in the loss of the Job Activity Monitor again.

Advertisements
Leave a comment

5 Comments

  1. Ariel

     /  January 4, 2012

    “We reran the installation and chose the advanced tools option and the Job Activity Monitor worked fine.”

    What installation did you run?

    Reply
  2. Hi! I linked this post of you, because this error happened to me a couple of weeks ago! Hope you dont mind. here is the linked post: http://thelonelydba.wordpress.com/2012/08/18/unable-to-open-job-activity-monitor-in-sql-2008-ssms-express/

    I’m also folowing your blog now. cya!

    Reply
  1. Unable to open Job Activity Monitor in SQL 2008 SSMS Express | The Lonely DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: