October 28, 2009 at 7:11 am
We have to data bases say 1 and 2 and we have restored the data base 1 and 2 from live to our test environment. We have a user with name appsa and when we try to logon to data base 1, we cant login.
We checked ---security--login-appsa--rt click---user mappings. one form appears with three fields data base name, user and default schema. Now the user name is showing dbo instead of showing appsa.
could you please let me know whaht could be the issue?
cheers
Siddarth
October 28, 2009 at 7:15 am
User is most likely orphaned from its login
run this command in the database
sp_change_users_login 'report'
if the appsa user is listed in the results set run this
sp_change_users_login 'update_one','appsa','appsa'
---------------------------------------------------------------------
October 28, 2009 at 7:18 am
When you restore the users move, but not the logins. The sp_change_users_login procedure can help you.
October 28, 2009 at 8:26 am
thanks alot for the info. We tried and unfortunately that didint worked for us. We are trying the whole process again.
cheers
Siddarth
October 28, 2009 at 8:31 am
post the actual error from the SQL error log when login fails, we need the state value. This could be something like incorrect default database if userid is not orphaned.
---------------------------------------------------------------------
October 29, 2009 at 10:52 am
The issue came because the data base id on live and test environment were different. We have correct the data base id and its sorted now. also the data base owner were different for same data base on 2 diff enronments.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply