Tagged: christopher Gillis
March 14, 2018 at 3:44 am #11376
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.
Help me to solve problem , If any one has correct SQL which needs to executed after db restore for SP12 , Please share.
~Thank You.March 16, 2018 at 1:45 pm #11392
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.
This should resolve the login issue you were seeing.
Aras Labs Software EngineerMarch 29, 2018 at 6:53 am #11463
Thank you Christopher
Its working and it helped me a lot.July 11, 2018 at 11:05 am #12109
Hi Christopher Gillis,
I executed above SQL after database restore.
Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 137
Terminating this procedure. The Login name ‘innovator_regular’ is absent or invalid.
Help me to solve problem…
Henry TuJuly 11, 2018 at 12:16 pm #12111
Could you check that the database you’re restoring is an SP12 database? You can find this by running the following SQL query against it within SQL Server Management Studio.
select name,value from innovator.variable where name = 'VersionServicePack' or name = 'VersionMajor'
Aras Labs Software EngineerJuly 11, 2018 at 9:52 pm #12114
Hi Christopher Gillis,
I backup Database from Aras SP9 and I was successful on recovery when on Aras SP9. Now, I want to restore Database to Aras SP12.
I think my wrong where, help me.
Henry TuJuly 12, 2018 at 9:07 am #12117
Databases are only compatible with the versions of Innovator they were created for. You will not be able to use an SP9 database with an SP12 instance of Innovator.
Aras does provide upgrade services for subscribers. If you are not an Aras subscriber, I recommend contacting our Community team for more information about this subscription benefit: firstname.lastname@example.org
Aras Labs Software Engineer
You must be logged in to reply to this topic.