Problem stopping and starting services.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Problem stopping and starting services.

Author

Topic

theonlylawislove
Starting Member

7 Posts

Posted - 2008-03-07 : 13:05:26

I'm hosting sqlserver 2005 developer edition locally on windows vista.

I'm getting messages for allot of stuff.

I can't restart, stop, or start my sql server instance.

I can't start the full-text search service.

I get this when I try to start the full-text search service.


===================================

Unable to start service MSFTESQL on server PAUL-PC.

===================================

Access Denied (ObjectExplorer)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()

And when I try to restart the instance...


===================================

Unable to stop service MSSQLSERVER on server PAUL-PC.

===================================

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)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-07 : 14:39:48

Did you install SQL Server 2005 service pack 2?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

hrscharf
Starting Member

1 Post

Posted - 2008-05-02 : 07:16:56

I experienced exactly the same problem under the same environment. On my system SQL Server 2005 Service Pack 2 is installed.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-03 : 20:29:09

Do you have proper permission to start/stop service on the machine?

mperillo
Starting Member

1 Post

Posted - 2008-05-04 : 14:46:18

I had the same problem. I was using Windows Auth to login. I assumed that I had dbo access, but I guess not. I logged in using the SA account (SQL auth) and was able to perform the tasks denied.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources