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