Solved

Missing services sql 2008 in configuration manager

Posted on 2011-03-22
16
1,006 Views
Last Modified: 2012-05-11
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
Comment
Question by:SBV_DEV2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
16 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35188371
Did yuou see this (it's for 2005 but should apply):
http://support.microsoft.com/kb/941823
0
 
LVL 9

Expert Comment

by:kaminda
ID: 35188380
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
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35188396
Is this a fresh install? Do you have any other versions of SQL Server installed (now or before)?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:SBV_DEV2
ID: 35188658
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
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35188786
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
 

Author Comment

by:SBV_DEV2
ID: 35188842
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
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35189098
Do you have SQL Server (MSSQLSERVER) in services? When did you install SQL 2008, did you apply service pack or update before?
0
 

Author Comment

by:SBV_DEV2
ID: 35189154
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
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35189216
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
 

Author Comment

by:SBV_DEV2
ID: 35196378
I have stopped and started WMI. Also restarted the machine. Unfortunately, still the same.
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35196478
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
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35196547
Before that please run follwoing command in the command prompt and send the output:
sc sdshow MSSQLSERVER
0
 

Author Comment

by:SBV_DEV2
ID: 35229555
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
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35229778
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
 

Accepted Solution

by:
SBV_DEV2 earned 0 total points
ID: 36003050
Thanks for the suggestions from everyone. I reinstalled SQL and it is now displaying correctly.
0
 

Author Closing Comment

by:SBV_DEV2
ID: 36038834
None of the suggested solutions was working for me.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question