4

Our Active directory will change the accounts name for example John Doe Jdoe@abcd.com to John.Doe@abcd.com.

My question is do I need to change all the SQL Logins individually or the person can login to SQL server management studio with their old names. What also happens if the login is an owner of a database or job.

3

SQL Server stores Active Directory accounts using a unique identifier generated by Active Directory. The unique identifier is generated when the object is created in Active Directory, and never changes.

This means you can change things like the user name, first name, last name, and any other Active Directory attribute for the user, without the need to even touch SQL Server or SSMS in any way.

In other words, you can change their account name in AD, and not worry about SQL Server at all.

| improve this answer | |
  • So it is linked to the SID and the users will login through SSMS using the old logins and in order for them to use their new login when using ssms i will have to alter the login and assign the new user. – SQL_NoExpert Aug 1 at 0:26
  • No, with Windows logins, it doesn't matter what the user name is or if it's been changed. They just connect using Windows Authentication through SSMS without any need to chsnge anything in SQL Server. – Max Vernon Aug 2 at 18:18
  • 1
    So I did a test and i found that everything works after change without having to change anything on the sql server and in fact the logins also got changed on the sql server and only SSMS was showing the old name and once the server got restarted showed the new name. Another important feature learned. Thank you @Max Vernon – SQL_NoExpert Aug 3 at 17:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.