Cannot Restart Analysis Services from SSMS Object Explorer - by Parveza

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 290872 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/3/2007 10:57:56 AM
Access Restriction Public


On trying to restart AS Service from SSMS we get eth following errors


Unable to stop service MSSQLServerOlapService on server AITDOLAP70.


Access Denied (ObjectExplorer)

Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Stop(Boolean stopDependentServices, Stack`1 stoppedDependentServices)


This message cannot be copied to the clipboard. (Microsoft SQL Server Management Studio)


Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. (System.Windows.Forms)

Program Location:

   at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
   at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy)
   at Microsoft.NetEnterpriseServers.ExceptionMessageBoxForm.CopyToClipboard()

Sign in to post a comment.
Posted by Microsoft on 8/6/2007 at 9:52 AM
To do service control within Management Studio (SSMS) on Windows Server 2008 (Longhorn) you need to run SSMS as administrator. Similar to Vista, Longhorn runs applications with limited administrator rights. You can also use SQL Server Configuration Manager to control services.

Lead Program Manager
SQL Server Manageability