SOLUTION - PROGRAM MANAGEMENT - Unable to Login after Restore Database in another System

Rahul. - Tuesday, November 8, 2011 5:43 AM:

Hi frnds

I am unable to login after restoring database in another System.

I am trying to login using userid- admin and password - innovator but unable to log in .

if any one have idea about this then please share it.

Thanks

Rahul

Boro - Tuesday, November 8, 2011 7:41 PM:

You should run these 3 queries against the restored database after finishing restore.

2nd query(grantdbaccess) may fail, but still continue.

------sql------

exec sp_change_users_login 'Update_One', 'innovator', 'innovator'

exec sp_grantdbaccess 'innovator','innovator'

exec sp_addrolemember 'db_owner','innovator'

---------------

Thanks.

Boro

Rahul. - Tuesday, November 8, 2011 10:20 PM: