May 27, 2005 at 4:41 am
I have finally restored my databases after having all sorts of problems but now I have a problem with the logins. The security settings for the logins on the original server have not been replicated on the server that the backups were restored. I read something about orphaned users in a response to one of my earlier postings but wasn't sure if this was related to my problem. Does anyone have any ideas?
Thanks
May 27, 2005 at 6:55 am
You'll need to map the old logins to ones on the new server (and if you want to keep the same ones make sure that the SQL logins exist first).
Have a look in BOL for 'sp_change_users_login' which should explain things adequately.
May 27, 2005 at 7:31 am
to resolve the issue of orphan users, refer to this link
http://www.sqlservercentral.com/columnists/glarsen/orphan_user.asp
To migrate users to a new server:
http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp
There is an article on Microsoft site on this topic
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133
HTH
May 27, 2005 at 8:07 am
Thank you all for your feed back
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply