How to change the default name of an instance?

Question

Rename or Change SQL Server Standalone Default Instance Step 1 : Check Current Instance & host name. . Step 2 : Rename Host name & reboot the server. Step 3 : Try to connect with SQL server admin-0783e4076 & you will face below error because no instance of server name [ADMIN-0783E4076] exists as server name got changed.

Can we change the instance name?

The process to change a SQL Server instance name has not changed from how it is done on a Windows based SQL Server. We need to drop the existing SQL Server instance name using system stored procedure sp_dropserver and then we need to add the new SQL Server instance name using system stored procedure sp_addserver.

How do I change the instance name of a database?

How To: Change Instance Name Of SQL Server1Run this in Microsoft SQL Server Management Studio: sp_dropserver 'old_name' go sp_addserver 'new_name','local' go.2Restart SQL Server service.

What is the default instance service name?

The default instance (if you install it) is listed as SQL Server (MSSQLSERVER).

Can you rename a SQL instance?

Renaming SQL Server instance name does not support if your instance has replication, except when you use log shipping with replication. You can change the name of SQL Server instance on secondary server in log shipping if the primary server is permanently lost.

Expert · Answer