How to Rename SQL Server Instance Name - SQL Server DBA Tutorial

In this video you will learn how to rename SQL Server instance using T-SQL Script, how to rename the add new host to SQL Server default instance server group in master database, how to add new host (new server name) of a named instance to server group in master database. How to resolve error:
Msg 15190, Level 16, State 1, Procedure sp_dropserver, line 44 there are still remote logins for the server
It also shows step by step work around of renaming SQL Server instance by creating an alias on application server. How to find out which port SQL Server is running and step by step process of creating Alias in SQL Server.


Script used in video to rename SQL Server Instance Name

--Rename Host of a default instance

sp_dropserver DynamicsAXDev;
GO
sp_addserver DynamicsAXTEST, local;
GO

sp_dropserver DynamicsAXDev\SQLTEST>;
GO
sp_addserver DynamicsAXDevTEST\SQLTEST, local;
GO
     
--Remote Login Issue and resolution for Default instance
sp_dropremotelogin DynamicsAXDev;
GO
----Remote Login Issue and resolution for Named instance
sp_dropremotelogin DynamicsAXDevTEST\instancename;
GO


How to Rename SQL Server Instance Name - SQL Server DBA Tutorial

2 comments:

  1. haring the article, and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too
    vidmate.onl

    ReplyDelete
  2. Welcome To Techbrothersit: How To Rename Sql Server Instance Name - Sql Server Dba Tutorial >>>>> Download Now

    >>>>> Download Full

    Welcome To Techbrothersit: How To Rename Sql Server Instance Name - Sql Server Dba Tutorial >>>>> Download LINK

    >>>>> Download Now

    Welcome To Techbrothersit: How To Rename Sql Server Instance Name - Sql Server Dba Tutorial >>>>> Download Full

    >>>>> Download LINK xa

    ReplyDelete