I have sucessfully install Aras Innovator SP12 & did couple of custmization work. I want to take that database backup so I created .bak file and try to restore it on difference machine. SQL server is successfully able to restore the database when I try to login with the admin/innovator login,getting below error.
"The Database is not available:Cannot open database "InnovatorSolutions_12" requested by the login. The login failed. Login failed for user 'innovator_regular'. "
Note:- Execute below SQL after database restore.
sp_change_users_login 'Update_One','innovator','innovator'
sp_addrolemember 'db_owner','innovator'
Help me to solve problem , If any one has correct SQL which needs to executed after db restore for SP12 , Please share.
~Thank You.