How to Rename Logins in SQL Server

In this article, we will be discussing about how to rename logins in SQL Server.

 

A Scenario Where You Might Need to Rename a Login in SQL Server

When a Database Administrator creates Windows Logins in SQL Server, the format of these logins is:

[Domain or Server Name]\[Windows Username]

[Domain] can also be the local Server name if the user is a local Windows User.

In the case where the Server name changes and the Windows Login names remain the same in SQL Server then the login will not be usable. To this end, these login names have to be renamed.

 

How Rename Windows Logins in SQL Server

The syntax for renaming Windows Logins in SQL Server is:

ALTER LOGIN "[Domain or Server Name]\[Windows Username]"
WITH NAME="[New Domain or New Server Name]\[Windows Username]"

*Note: You have to use the double quotes.

 

How to Rename SQL Logins in SQL Server

If you want to rename a SQL Server login (SQL Server Authentication) you can use one of the following syntaxes:

Syntax 1:

ALTER LOGIN "[SQL Server Login Name]"
WITH NAME="[New SQL Server Login Name]";

 

Syntax 2:

ALTER LOGIN [SQL Server Login Name]
WITH NAME=[New SQL Server Login Name]

As you may noticed from the above two examples, you can either select to use or not double quotes.

 

 

Strengthen your SQL Server Administration Skills – Enroll to our Online Course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Learn More

 

Featured Online Courses:

 

Read Also:

 

Check our other related SQL Server Administration articles.

Subscribe to our newsletter and stay up to date!

Check out our latest software releases!

Check out our eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub