June 7, 2011 at 3:17 am
Hi Team,
I am trying to migrate logins from one server to another.
So i generated the login script using sp_help_revlogin.
I executed the output in the destination server and i got all the logins in the destination server.
But the problem is i am not getting the proper @access rights" as of source server in the destination server.Logins are getting connected.But access is missing.
Any help will be appreciated
June 7, 2011 at 4:42 am
Try applying login fix for some of the logins and check.
June 7, 2011 at 4:44 am
EXEC sp_change_users_login 'Auto_Fix', 'User'
June 7, 2011 at 4:54 am
haichells (6/7/2011)
EXEC sp_change_users_login 'Auto_Fix', 'User'
above query is to vheck the unmapped users right?
when the logins whose SID is not mapped
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply