SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name

September 9, 2008 by pinaldave

If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together on same physical server, changing the name of the server (computer) using operating system may create non-functional SharePoint website.

When you change the physical server name the SharePoint is already connected to the SQL instance of old computer name (OldServerName/SQLInstance) and on changing the name the SharePoint will not able to connect the SQL Server as now the SQL Server instance will run on new computer name (NewServerName/SQLInstance).

To solve this problem you need to reconfigure the entire Microsoft Office SharePoint Server with SQL Server Instance. Please follow the steps to fix the issue.

1. Open command prompt, change directory to where stsadm.exe exists.

C:\cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

2. To invoke setconfigdb operation we need to use stsadm.exe. Run following command on command prompt

stsadm.exe -o setconfigdb -databaseserver ServerName -farmuser MyUserName – farmpassword MyPassword

3. Go to IIS, All Programs>>Administrative Tools>>Internet Information Service (IIS) Manager.

4. Right Click SharePoint Central Administration v3, click on delete and re-run the configuration wizard; the web application will be re-created by the configuration wizard.

5. After the above operation has completed successfully, run the SharePoint Products and Technologies Configuration Wizard.

All Programs>>Microsoft Office Server >> SharePoint Product and Technologies Configuration Wizard

6. Complete all the steps of wizard by clicking on Next button.

At the end of this process you will get a success wizard.

On completion of this whole procedure Microsoft Office SharePoint Server gets connected to the database with new Computer Name.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, Software Development, T SQL, Technology | Tagged SharePoint | 4 Comments

4 Responses

on September 10, 2008 at 7:00 am | Reply SQLAuthority News - SharePoint - Steps To Create A Custom WebPart - Deploy It SharePoint Site Journey to SQL Authority with Pinal Dave

[...] on one large project of SharePoint. Based on users feedback and overwhelming response to article SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name I am posting one more article which is very important for SharePoint [...]
on January 12, 2009 at 7:22 pm | Reply Nazeer Basha Shaik

Hi pinaldave,

I am working on Sharepoint 2007. I am facing problem with SPSites when My computer name is changed. No sites is working after I change the Computer Name. I follow the steps provided by you to solve this Issue. Once the Configuration wizard is Completed successfull ( That is last step ) it is open the central administration site. In Central administration site one option is available to check the web application lists. when i open the link it is showing only the Central administration Site in Web application list ( Before changing the Computer Name i have 10 Shrepoint sites in IIS which are working without showing any error) How can i make them to work.

Thanks
Nazeer Basha Shaik
on July 1, 2009 at 6:37 am | Reply Josh

I have an existing server farm and the SQL Server computer changed. I cannot connect to the SQL Server and when I have tried to run through the wizard I first disconnect from the farm and again re-run the wizard. But, I cannot connect the existing SQL Server under the new name. Any help would be great.

Thanks, Josh

SQL Server 2005
Sharepoint 2007
on September 2, 2009 at 10:18 pm | Reply Brian Bedard

You need this as well.

http://support.microsoft.com/default.aspx/kb/934838/en-us