locked
Service fails to start on dependancy service RRS feed

  • Question

  • Windows 2003 R2 Standard server

    SharePoint 3.0

    SQL 2005 Server

    I just uninstalled SQL 2005 server from my Windows 2003 Server

    The SharePoint databases are now on my SQL 2008 Server which is on a Windows 2008 R2 Standard 64 bit server.

    When the sharePoint services try to start they fail

    Type :  Error
    Date :  10/8/2012
    Time :  7:22:16 PM
    Event :  7003
    Source :  Service Control Manager
    Category : None
    User :  N/A
    Computer : Server01
    Description:
    The Windows SharePoint Services Administration service depends on the following nonexistent service: MSSQLSERVER

    When I check the properties of the service and look at the dependencies there are no entries.

    So where can I look to see this?

    can I make it depend on the service on my windows 2008 server which is running the sql 2008 server?

    Thanks

    Tom


    Thomas R Grassi Jr

    • Moved by Cicely Feng Tuesday, October 9, 2012 8:44 AM (From:General)
    Monday, October 8, 2012 11:44 PM

Answers

  • 1.) Should be a DependOnService multi string under SharePoint Services Administration service subkey found in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services

     http://support.microsoft.com/kb/193888

     

     2.) Doubtful and don't think that would be desireable/stable anyway.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 12:03 AM
  • Dave

    I was already looking at the services in ther registry.

    I removed the mssqlserver from the list and left it blank

    But the service still is looking for mssqlserver.

    Do I need to restart or delete the entire entry

    Thanks

    Tom


    Thomas R Grassi Jr

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 12:26 AM
  • From a windows perspective this should work. Might also want to run this by them in the sharepoint group in case its part of some configuration.

     

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 12:54 AM
  • Dave

    I will give it a try

    The SharePoint group does not respond as does the other groups on here.

    I have posted several questiosn there and no answer.

    I give it a try any way.


    Thomas R Grassi Jr

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 1:09 AM
  • Ok, sounds good.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 1:14 AM
  • I don't know sharepoint much, but it seem to me as sharepoint still think it's has to load the database up. (Even if the depend on is left blank) Any wizard, config to change to make it look somewhere else ?

    From sharepoint, did you move the database with a wizard, or you did it by hand ?

    I would tend to check post like; http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/3b1d5334-0182-4704-8f33-c8cf2257ef2f/


    MCP | MCTS 70-236: Exchange Server 2007, Configuring

    Want to follow me ?  |  Blog: http://www.jabea.net | http://blogs.technet.com/b/wikininjas/

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:18 PM
    Tuesday, October 9, 2012 1:15 AM
  • Dave.

    After I removed DependOnService from the registry entry for the service I then restarted the server and the services are now able to start.

    Now off to SharePoint land to see what else I need to do.


    Thomas R Grassi Jr

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:19 PM
    Tuesday, October 9, 2012 12:19 PM

All replies

  • 1.) Should be a DependOnService multi string under SharePoint Services Administration service subkey found in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services

     http://support.microsoft.com/kb/193888

     

     2.) Doubtful and don't think that would be desireable/stable anyway.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 12:03 AM
  • Dave

    I was already looking at the services in ther registry.

    I removed the mssqlserver from the list and left it blank

    But the service still is looking for mssqlserver.

    Do I need to restart or delete the entire entry

    Thanks

    Tom


    Thomas R Grassi Jr

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 12:26 AM
  • From a windows perspective this should work. Might also want to run this by them in the sharepoint group in case its part of some configuration.

     

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 12:54 AM
  • Dave

    I will give it a try

    The SharePoint group does not respond as does the other groups on here.

    I have posted several questiosn there and no answer.

    I give it a try any way.


    Thomas R Grassi Jr

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 1:09 AM
  • Ok, sounds good.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:17 PM
    Tuesday, October 9, 2012 1:14 AM
  • I don't know sharepoint much, but it seem to me as sharepoint still think it's has to load the database up. (Even if the depend on is left blank) Any wizard, config to change to make it look somewhere else ?

    From sharepoint, did you move the database with a wizard, or you did it by hand ?

    I would tend to check post like; http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/3b1d5334-0182-4704-8f33-c8cf2257ef2f/


    MCP | MCTS 70-236: Exchange Server 2007, Configuring

    Want to follow me ?  |  Blog: http://www.jabea.net | http://blogs.technet.com/b/wikininjas/

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:18 PM
    Tuesday, October 9, 2012 1:15 AM
  • Dave.

    After I removed DependOnService from the registry entry for the service I then restarted the server and the services are now able to start.

    Now off to SharePoint land to see what else I need to do.


    Thomas R Grassi Jr

    • Marked as answer by TRGOneCare Tuesday, October 9, 2012 12:19 PM
    Tuesday, October 9, 2012 12:19 PM
  • Good to hear of progress.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Wednesday, October 10, 2012 12:23 AM