If you have Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) running on the same physical server, changing the name of the server using the operating system may cause your SharePoint website to become non-functional. This is because SharePoint is already connected to the SQL instance of the old computer name, and changing the name will prevent SharePoint from connecting to the SQL Server on the new computer name.
To solve this problem, you need to reconfigure the entire Microsoft Office SharePoint Server with the new SQL Server instance. Follow the steps below to fix the issue:
- Open the command prompt and change the directory to where stsadm.exe exists. For example, type:
C:\cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN - To invoke the setconfigdb operation, use stsadm.exe. Run the following command on the command prompt:
stsadm.exe -o setconfigdb -databaseserver ServerName -farmuser MyUserName – farmpassword MyPassword - Go to IIS by navigating to All Programs >> Administrative Tools >> Internet Information Service (IIS) Manager.
- Right-click on SharePoint Central Administration v3 and click on delete. Then, re-run the configuration wizard. This will re-create the web application.
- After the above operation has completed successfully, run the SharePoint Products and Technologies Configuration Wizard. You can find it under All Programs >> Microsoft Office Server >> SharePoint Product and Technologies Configuration Wizard.
- Complete all the steps of the wizard by clicking on the Next button. At the end of this process, you will receive a success message.
By following these steps, you will successfully connect your Microsoft Office SharePoint Server to the database with the new computer name.
It is important to note that changing the server name should be done with caution, as it can have implications on the functionality of your SharePoint website. Always ensure that you have a backup of your SharePoint data and consult with your IT team before making any changes to the server name.
Thank you for reading! We hope this article has helped you resolve any issues you may have encountered when changing the SQL Server name for your SharePoint website.