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’. “
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.