How To Rename Your SQL Server Default Instance Or Named Instance

In this tutorial i will explain How To Rename Your SQL Server Default Instance Or Named Instance.Have you ever had to change the name of SQL Server. If yes, Then follow these steps to do this.

Open Sql server management studio.
See your server name :- Select @@servername
Now run this :- sp_dropserver ‘your server name’
If you get any error like this:-

Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 56

There are still remote logins or linked logins for the server 'servername'

5. Then run this sp_helpserver and you will find your list of linked server.Firstly remove them with

 sp_dropserver 'linked server name'

6.Now drop your server and then add your server name what you want by this:-

 sp_addserver 'new server' , local

7. Now restart SQL Server and SQL server agent.