Steps to Change SharePoint Database "Server Name/IP Address

Steps to Change SharePoint Database "Server Name/IP Address"

Step 1: Login to SharePoint Application Server and Run SharePoint Production Wizard

Step 2: Disconnect the database from Application Server

Step 3: Login to the SharePoint Database Server and Change the Database Server IP Address/Server

Step 4: Open Microsoft Sql Server Management Studio

Step 5: Go to SharePoint_Config Database and Run the following command to change the Exist database IP Address/Server

Find Server Name/IP Address Command (ID Example only):
select * from Objects where id='E41F2DE6-4003-4F8F-BA3C-AFF155B1A643'

Update Server Name/IP Address Command (ID Example only) :
begin tran
update Objects set Name='pkravdb2.naieng.nai.org' where Id='E41F2DE6-4003-4F8F-BA3C-AFF155B1A643'
commit tran

Step 6: Again start run the SharePoint Product Wizard