How to Rename Logins 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.

 


Learn more tips like this! Get the Online Course!

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

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 / Downloadable Resources and more!

Enroll Now with Discount!


 

Check our Featured Online Courses:

 

Read Also:

 

Check our latest software releases!

Easily generate SQL code snippets with Snippets Generator!

Convert static T-SQL to dynamic and vice versa with Dynamic SQL Generator.

 

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