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 2008 Forums
 SQL Server Administration (2008)
 No services listed in SQL Server Config Manager

Author  Topic 

rupertsland
Starting Member

9 Posts

Posted - 2012-11-26 : 14:20:27
Hello.

I'm really stuck. On the weekend, Microsoft Windows updates were applied to our server. This morning, I was able to log into our SQL Server instances and databases, but I was horified to see that SQL Server Configuration Manager (SSCM) no longer lists all the services under the SQL Server Services node. Instead, I see an error message "The remote procedure call failed. [0x800706be]" I can't get any info on the error and am left baffled.

What should I do to get all the services listed again in SSCM?

We are running Windows Server 2008 Standard with SP2, with SQL Server 2008 Standard.


Cheers

-------------------
Rupertsland,
Canada

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-26 : 14:28:21
Do the services exist in the Services applet? (Admin Tools..Services)

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

Subscribe to my blog
Go to Top of Page

rupertsland
Starting Member

9 Posts

Posted - 2012-11-27 : 14:08:49
quote:
Originally posted by tkizer

Do the services exist in the Services applet? (Admin Tools..Services)

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

Subscribe to my blog



No, they are not listed.

The only services I see now are for SQL Server Express - which was installed separately a couple years ago (came with ESRI ArcGIS Server package).


Cheers

-------------------
Rupertsland,
Canada
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-27 : 14:17:02
I think you need to open a case with Microsoft on this. If the SQL Server still can be connected to but the services are not there, well that's something Microsoft needs to help with.

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

Subscribe to my blog
Go to Top of Page

rupertsland
Starting Member

9 Posts

Posted - 2012-11-28 : 13:44:09
quote:
Originally posted by tkizer

I think you need to open a case with Microsoft on this. If the SQL Server still can be connected to but the services are not there, well that's something Microsoft needs to help with.

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

Subscribe to my blog



Hi Tara.

Thanks for your help. I've spoken with our IT guys. They attempted a reinstall, but that failed. They are now on the phone with Microsoft trying to resolve the problem.

Cheers

-------------------
Rupertsland,
Canada
Go to Top of Page
   

- Advertisement -