September 23, 2013 at 3:15 pm
I receive the following messages when trying to use activity monitor in SSMS
Error:
The activity monitor is unable to execute queries against server.
activity monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.
Additional Information:
The RPC server is unavailable. (Exception for the HRESULT: 0x800706BA) (mscorlib)
September 23, 2013 at 3:44 pm
September 23, 2013 at 3:54 pm
SQL server 2012
Windows Server 2008R2
September 23, 2013 at 4:10 pm
Checkout this ... http://connect.microsoft.com/SQLServer/feedback/details/770897/after-installing-sp1-sql-server-2012-activity-monitor-gives-access-denied.
are you using service pack 1 ?
September 24, 2013 at 8:20 am
NO SP1 is installed on the server .
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy