When try to open 'Activity Monitor' in the 'Management' folder, I get " MS SQL Server Error 297".
Unable to execute requested command.
------------------------------ Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc) at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
===================================
Unable to launch Activity Monitor. You may not have sufficient permissions. (Microsoft.SqlServer.Express.ActivityMonitor)
then the error is telling you the exact problem, you do not have permission to do what you are trying to do, almost certainly because you are accessing the server remotely.