Installed sql server 2008 entrprise edition on VM server windows 2008 (64bit). When launch Activity Monitor, get:
The Acityvity Monitor is unable to execute queries against server <server name>.
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.
ÃÂ ÃÂ Unable to find SQL Server process ID xxxx on server <server name>
ÃÂ ÃÂ (Microsoft.SqlServer.Management.ResourceMonitoring)
Tried to "use he context menu in the overview pane to resume the Activity Monitor" and got the same error again.
Installed sql 2008 in my XP machine, I can use Activity Monitor (AM) for local instance but cannot launch it for the instance on the server (same error).
Used windows authentication with sysadmin role for connection from my machine. On the server used domain\administrator that the account created the instance.
View Complete Post