Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1127
  • Last Modified:

Missing services sql 2008 in configuration manager

I am running SQL 2008 R2 Enterprise on Windows 2003. I cannot see the Sql server and Sql server agent in the configuration manager. I can see it on the Services screen. Any suggestions please?
0
SBV_DEV2
Asked:
SBV_DEV2
  • 8
  • 7
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
Did yuou see this (it's for 2005 but should apply):
http://support.microsoft.com/kb/941823
0
 
kamindaCommented:
It can happend due to several reasons.

First check wether your WMI service started or not. Try restarting it. Chech whether it solved your issue.

If not most common issue is a bad installation of the SQL Server or a Service Pack, In that case you will have to reinstall the SQL Server.
0
 
Daniel_PLDB Expert/ArchitectCommented:
Is this a fresh install? Do you have any other versions of SQL Server installed (now or before)?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
SBV_DEV2Author Commented:
I have enabled the WMI service. It still does not work.

I have Sql 2005 installed as well.  Sql 2008 R2 is the default instance.
0
 
Daniel_PLDB Expert/ArchitectCommented:
Have you tried both versions of configuration manager, are they both not working?
Start->run->(type) sqlservermanager.msc          --- for Sql Server 2005
Start->run->(type) sqlservermanager10.msc      --- for Sql Server 2008
0
 
SBV_DEV2Author Commented:
SQL Server 2008 brings back the following:

SQL Server Integration Services
SQL Server Integration Services 10.0
SQL Server FullTest Search (SQL2005)
SQL Server (SQL2005)
SQL Server Agent (SQL2005)
SQL Server Browser

SQL Server 2005 displays all of the above except the second line - SQL Server Integration Services 10.0
0
 
Daniel_PLDB Expert/ArchitectCommented:
Do you have SQL Server (MSSQLSERVER) in services? When did you install SQL 2008, did you apply service pack or update before?
0
 
SBV_DEV2Author Commented:
Yes I have Sql Server(MssqlServer) and Sql server agent (mssqlserver) in Services.

I originally had SQL 2000 as the default instance. I removed it and installed SQL 2008 R2 as the default instance. I did not apply and service pack updates. The Services were listed in the Configuration Manager when the instance was installed. It is only recently that I noticed that it does not appear there any longer.
0
 
Daniel_PLDB Expert/ArchitectCommented:
Have you tried to restart WMI:
NET STOP "Windows Management Instrumentation"
NET START "Windows Management Instrumentation"

Have you tried to restart whole machine - if possible?
0
 
SBV_DEV2Author Commented:
I have stopped and started WMI. Also restarted the machine. Unfortunately, still the same.
0
 
Daniel_PLDB Expert/ArchitectCommented:
In this case I suggest you to repair your SQL Server installtion.
http://msdn.microsoft.com/en-us/library/cc646006%28v=SQL.100%29.aspx
0
 
Daniel_PLDB Expert/ArchitectCommented:
Before that please run follwoing command in the command prompt and send the output:
sc sdshow MSSQLSERVER
0
 
SBV_DEV2Author Commented:
Results from previous post:

D:(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)(A;;CCLCSWLOCRRC;;;I
CRSDRCWDWO;;;S-1-5-21-1060887928-1483748127-291861362-4473
CRSDRCWDWO;;;SY)S:(AU;FA;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;WD)
0
 
Daniel_PLDB Expert/ArchitectCommented:
I think this part of your string is not valid, are you sure it's correctly pasted?:
(A;;CCLCSWLOCRRC;;;I
CRSDRCWDWO;;;S-1-5-21-1060887928-1483748127-291861362-4473
CRSDRCWDWO;;;SY)


There may be problems when one set some group policies incorrectly. You can find out which policies are applied it may also be problematic - resultant set of policies.
0
 
SBV_DEV2Author Commented:
Thanks for the suggestions from everyone. I reinstalled SQL and it is now displaying correctly.
0
 
SBV_DEV2Author Commented:
None of the suggested solutions was working for me.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now