How to Rename or change the SQL instance name in SharePoint Farm with multiple servers

Question

Hi Team,

We have 2 SharePoint 2019 servers and 1 SQL 2016 server in our environment.

SharePoint and SQL is configured with direct instance name, which means without any alias name.

Now the issue is our SQL server got corrupted and we want to change the SQL server with new IP, new Hostname, new Instance Name.

Can you please provide and guide best practice to change the SQL Instance name in SharePoint farm.

Answer 1

Hi @Rahul Gollapalli ,

If you don't use a SQL Server client alias during the SharePoint installation, you can follow the below steps to migrate the SQL server from one to another.

Note: Before you start, create a backup of the configuration database for troubleshooting in case the SharePoint farm becomes inaccessible when you perform the steps.

• Create a new SQL alias on all SharePoint servers in the farm.
• Point the SharePoint databases to the new SQL alias.
• Point the default database instance for the web applications to the new SQL Server instance.
• Change the Distributed Cache cluster configuration.
• Reprovision the Distributed Cache service on all Distributed Cache servers.
• Remove reference to the old server.

You can find detailed steps at: How to change the database server in a SharePoint farm.

----------

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.