sp_change_users_login

[KingSexy182]

sp_change_users_login can be used only for SQL Server logins; it cannot be used with Windows logins.

Is there an alternative to map windows loggins other than to do these steps:
- sp_revokelogin
- sp_grantlogin
- grant permissions

????????

[skhanal]

No there is no easy fix

[rmiao]

Don't need remap db user to windows users after db restoring as long as the login is in sql server.

[Rawhide]

The only shortcut that comes to mind is to write the steps into your own stored procedure named sp_something and save it in the master database. Then just call the sp.

[KingSexy182]

thanks heaps guys.

i tested it out by backing up a db on server A and restoring it on server B; then compared the before and after results on NT Logins after a restore. It appears that if that login exists in the new server, their fixed server role on that server does not change, and user permissions did not needed re-mapping if it had existed in the first place. thank rmiao.

[skhanal]

I thought you had mismatched windows login. If you are moving databases in the same domain then the SID remain same so everything will map, however if you ever have to move from one domain to another then you need to recreate the logins.

[KingSexy182]

my apologies skhanal;
im still learning,
thats why im using these forums.
Ill try to be a bit clearer in the future.