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.
Hello,
In 11.0 SP12, we introduced a new SQL user called 'innovator_regular' for security reasons. In addition to the SQL queries you ran after you restored the database, you should also run the SQL query below.
sp_change_users_login 'Update_One','innovator_regular','innovator_regular'
This should resolve the login issue you were seeing.
Chris
Christopher Gillis
Aras Labs Software Engineer
Hello,
In 11.0 SP12, we introduced a new SQL user called 'innovator_regular' for security reasons. In addition to the SQL queries you ran after you restored the database, you should also run the SQL query below.
sp_change_users_login 'Update_One','innovator_regular','innovator_regular'
This should resolve the login issue you were seeing.
Chris
Christopher Gillis
Aras Labs Software Engineer
