Missing Services SQL 2005 Services in SQL Configuration Manager

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Missing Services SQL 2005 Services in SQL...

20 posts, Page 1 of 2

1 2 »»

Missing Services SQL 2005 Services in SQL Configuration Manager

Rate Topic

Display Mode

Topic Options

Author

Message

vinny.vekaria

Posted Tuesday, September 23, 2008 8:29 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 5:36 AM
Points: 13, Visits: 24

Hi Folks,

When using SQL configuration manager in SQL 2005, none of the SQL 2005 Services are listed other than integration services. You may ask why not use services.msc. Our developer wishes to setup startup parameters for the agent stratup which you can in the configuration manager.

Any ideas?

cheers
Vinny

Post #574408

Luke L

Posted Tuesday, September 23, 2008 8:36 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:42 AM
Points: 2,891, Visits: 5,858

any chance whoever installed it just installed the tools instead of the actual server components?

Are they listed in the Services console?

-Luke.

To help us help you read this

For better help with performance problems please read this

Post #574419

vinny.vekaria

Posted Tuesday, September 23, 2008 8:40 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 5:36 AM
Points: 13, Visits: 24

Hi Luke,

All the relevant services are listed in the services console, i.e sqlserver(MSSQLSERVER), sql agent, etc.

It's definately a full blown install of SQL 2005 as i have connected to the server using management studio and sucessfully restarted the services in the service console.

Thanks
Vinny

Post #574428

vinny.vekaria

Posted Tuesday, September 23, 2008 8:42 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 5:36 AM
Points: 13, Visits: 24

It is almost as if the WMI isnt reporting back to the configuration manager rest of the services.

Post #574436

Luke L

Posted Tuesday, September 23, 2008 8:48 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:42 AM
Points: 2,891, Visits: 5,858

That was gonna be my next question.. Is the WMI service started? what happens if you restart the WMI Service. What happens if you restart the server?

-Luke.

To help us help you read this

For better help with performance problems please read this

Post #574450

vinny.vekaria

Posted Tuesday, September 23, 2008 8:51 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 5:36 AM
Points: 13, Visits: 24

I've tried a restart of the server previously to no avail, I've just tried manually restarting the WMI service a few minutes ago with same results.

Post #574457

Luke L

Posted Tuesday, September 23, 2008 9:29 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:42 AM
Points: 2,891, Visits: 5,858

what about permissions, does the account you are logging in with (and connecting to Config Mgr with) have admin right to the Server to stop and start windows services?

this is all sounding somewhat familiar. Like perhaps what I went through installing Dev Ed on my Vista machine... You need to specify that you want to launch it with admin rights in order to start/stop services etc... That way the UAC popup will greet you when you first launch SSMS, SSCM, Visual Studio etc, but once you click ok to that you keep the elevated rights until you close the app.

-Luke.

To help us help you read this

For better help with performance problems please read this

Post #574536

vinny.vekaria

Posted Tuesday, September 23, 2008 9:38 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 5:36 AM
Points: 13, Visits: 24

Hi Luke,

I'm logging onto the server directly using domain admin on 2003 server. I came across a few blogs that suggest a bad install or service pack may be a cause. Forutuantely the server is not heavily used and only contain 2 small databases. I am completely uninstalling SQl after detaching the databases and perfrom a reinstall with full installation and no service pack. I will let you know the outcome shortly.

Cheers
Vinny

Post #574550

vinny.vekaria

Posted Tuesday, September 23, 2008 10:14 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 5:36 AM
Points: 13, Visits: 24

Hi Luke,

Looks like the re-install has done the trick, all services listed in configuration manager. Althought I havent yet applied any service pack, I;ll leave the service packs until further testing on a non production server.

Thanks for you help thus far.

Vinny

Post #574598

vinny.vekaria

Posted Wednesday, September 24, 2008 5:38 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, March 23, 2011 5:36 AM
Points: 13, Visits: 24

Hi,

After the re-install last night the services were listed at expect in SQL configuration manager, however when i came in this morning they were gone, this ones had me baffled as nothing on the server has been changed since last night.

Post #575077

« Prev Topic | Next Topic »

20 posts, Page 1 of 2

1 2 »»

Permissions