Hi, is it possible to change the name of a login on sql server 2000 from :
domain1\myuser to domain2\myuser
The authentication is windows mode.
Thank you
You cannot change logins for windows accounts.
You will have to add the domain2 logins and then map them to the databases as necessary.
It is possible to change SQL Server logins using sp_changeuserslogin system stored procedure, but I do not believe this will work with windows accounts.
No comments:
Post a Comment