SQL Server runs as a service named MSSQLServer. For a renamed computer that hosts a named instance of SQL Server, run the following procedures: sp_dropserver ; GO sp_addserver , local; GO Restart the instance of SQL Server. After the Renaming Operation If you install multiple instances on the server, you will see more than one SQL Server (InstanceName) listed. Follow below steps to change SQL Server instance name. How to get SQL Server instance name. The installation allows you to set a different value for the ID than the Name, although typically they're the same. For Authentication, select Windows Authentication. To get SQL Server instance name or service name uses the function named @@SERVICENAME. The Instance Name and Instance ID are different properties, yet Instance ID tends to be defaulted to a capitalized version of the Instance Name. Restart the instance of SQL Server.
For Server name, enter the name of your SQL Server instance. In the SSCM, click SQL Server Services under SQL Server Configuration Manager (Local), you could find list like SQL Server (InstanceName), The InstanceName is what we need to find, instance name. Learn how to find sql server Management Studio instance name in command prompt using sqlcmd - L and sql server 2014 configuration manager properties. --Drop existing name sp_dropserver [old_Instance_name]; GO --Update New name sp_addserver [new_Instance_name], local; GO If you have installed a named instance on your database server then you can run below command to change SQL Server Instance name. Syntax. (This article uses the instance name SQL2016ST on the hostname NODE5 [NODE5\SQL2016ST].) If you're unsure how to determine your SQL Server instance name, see Additional tips and tricks for using SSMS.