Share via

Cannot find MSSQLSERVER service in the services list

  • Article

Question

Saturday, December 4, 2010 8:37 AM

I have installed mssql2005 on win7 ultimate. I have installed sql sp3, as well. The problem is I cannot find MSSQLSERVER service, therefor I cannot start the ervice and for this reason I cannot do anything. I have uninstalled and installed the software again, but no success so far.

All replies (4)

Saturday, December 4, 2010 10:26 AM âś…Answered

Are you using the SQL Server configuration manager? You should run that from under Programs->SQL Server 2005 -> Configuration Tools -> Configuration Manager and not use the services snap-in. Have a look at the following for details...

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuration-manager.html

...do you see the SQL Server (MSSQLSERVER) from the configuration manager?

 

Thanks

/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem

Saturday, December 4, 2010 5:33 PM

I have installed mssql2005 on win7 ultimate. I have installed sql sp3, as well. The problem is I cannot find MSSQLSERVER service, therefor I cannot start the ervice and for this reason I cannot do anything. I have uninstalled and installed the software again, but no success so far.

Which edition of SQL Server did you install? While installing did you select Database Services?

Pradeep Adiga
Blog: sqldbadiaries.com

Saturday, December 4, 2010 5:55 PM

In addition to Pradeep's and moort's questions; did you install the DB Engine as a default instance or a named instance? MSSQLSERVER is the service name for a default instance, if you installed as a named instance the service name will be based on the instance name.Alan Brewer [MSFT] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights.

Saturday, December 4, 2010 7:18 PM

I have installed enterprise edition. I installed default instance. Surprisingly, even when I want to unistall it, using add/remove programs, there is no capacity shown in front of sql server component, meaning it has not been installed! while the name is there and any atempt to reinstall gets a message saying it has been installe so far! Opening configuratio management doesn't show the instance, as well. Regards