Home Dashboard Directory Help
Search

Cannot Restart Analysis Services from SSMS Object Explorer by Parveza


Status: 

Closed
 as By Design Help for as By Design


0
0
Sign in
to vote
Type: Bug
ID: 290872
Opened: 8/3/2007 10:57:56 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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()

Details
Sign in to post a comment.
Posted by Microsoft on 8/6/2007 at 9:52 AM
Hello,
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.

Thanks,
Dan
Lead Program Manager
SQL Server Manageability
Sign in to post a workaround.