locked
Cannot change the SQL Server address in WSS 3.0 (could not connect to WSS_Config database) RRS feed

  • Question

  • Dear all,

    Because of running out of IPs to provide for local network, IT guys changed the IP of the SQL Server which WSS 3.0 used to connect to. So, the WSS 3.0 could not work, even connect to the SharePoint Administrative Control Panel.

    I made search on internet for couple of days and do the following changes:

    - Update the registry key [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDB] dns to point to the new IP

    - Make a search on the whole Registry for the old IP but not found.

    - Make a search on whole files (look in content) to see the old IP, and not found.

    When I try to connect to SharePoint Administration Center, it shows Unknow error, and when see the Event Log, I found some error from connection to SQL Database, and the connection still points to the old IP of SQL Server

    I made reboot server many times, also, check all Windows Share Point Services in Services snap-in, all were started.

    Any help is appreciated

    This is the message from event log

    =================

    The description for Event ID 27745 from source Windows SharePoint Services 3 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    #50071: Unable to connect to the database WSS_Config on 192.168.20.222\MSSQLTFS.  Check the database connection information and make sure that the database server is running.

    the message resource is present but the message is not found in the string/message table

    =================

    Thank a lot

    • Edited by Mike Walsh FIN Friday, March 11, 2011 8:56 AM and looking forward to your helps removed.
    Friday, March 11, 2011 8:38 AM

Answers

  • Hi,

    Thanks to share your post.

    For the issue, do you mean that you could not connect to the WSS_Configdatabase?  If yes, it should be some reasons: you cannot connect to the database because of the fire wall, login credentials, network failure. Or the IIS is running in the wrong mode.

    Or you should check the web.config, find the error issue, and post it here.

    And there is the same article about this issue:

    http://prasanjitmandal.blogspot.com/2010/05/how-to-fix-central-administration.html.

    Hope this could help you!

    Leo

    • Marked as answer by Emir Liu Tuesday, March 29, 2011 9:35 AM
    Wednesday, March 23, 2011 7:48 AM

All replies

  • Check your host file. If there is entry for the database server with the old IP, this needs to be changed.

    Thanks,
    Dip


    Dip
    http://dzeee.net/sharepoint
    Friday, March 11, 2011 1:57 PM
  • I use IP for the SQL Server, not user the name. Also, hosts file is default one of Windows.

    Check your host file. If there is entry for the database server with the old IP, this needs to be changed.

    Thanks,
    Dip


    Dip
    http://dzeee.net/sharepoint

    Business Analyst www.nguyenhoangminh.info
    Tuesday, March 15, 2011 3:08 AM
  • Hi,

    Thanks to share your post.

    For the issue, do you mean that you could not connect to the WSS_Configdatabase?  If yes, it should be some reasons: you cannot connect to the database because of the fire wall, login credentials, network failure. Or the IIS is running in the wrong mode.

    Or you should check the web.config, find the error issue, and post it here.

    And there is the same article about this issue:

    http://prasanjitmandal.blogspot.com/2010/05/how-to-fix-central-administration.html.

    Hope this could help you!

    Leo

    • Marked as answer by Emir Liu Tuesday, March 29, 2011 9:35 AM
    Wednesday, March 23, 2011 7:48 AM