Did the restore. made sure I could access the new db with sa.. no
See some orphan logins that don't work (expected)..
did this to report them:
Exec sp_change_users_login 'REPORT'
did this on one of them:
Exec sp_change_users_login 'Update_One', 'xxxx', 'xxxx'
But got error:
Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line
131 Terminating this procedure. The Login name 'xxxx' is absent or
Also, There are users that access the old DB with their Windows User
name or AD name. I don't see them in the user access list for the db
and can't seem to map them to some of the AD groups that have access.
Is there any way to report exactly with what AD group a user was able
to access a DB? There isn't any setting that would allow everybody in
a domain to access a db without an AD group right?
Thanks for any help or information.
View Complete Post