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

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. Blog post link for the video: http://sqlage.blogspot.com/2015/03/how-to-rename-sql-server-instance-name.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html