using sp_help_revoklogin in a new server. 1

[Jimmy24]

Dear Sir or Madam,

I have restored 2 new database into a new server, this new server has not login, I need to run sp_help_revoklogin, do I need to run the sp on the old server or the new server. I am a little confuse how to use the sp.
Thanks in advance for your help

 

[ptheriault]

On which server do you want to remove the login? Also, If your SIDS don't match then login is orphaned and you need to either delete it or fix it.

First run

sp_change_users_login 'REPORT'

This will show you all the logins that are orphaned.

If you need to fix them run

sp_change_users_login 'update_one', 'login', 'login'


After you fix the logins you can then revoke the permissions.

- Paul
- If at first you don't succeed, find out if the loser gets anything.