Forum Discussion

Shankar's avatar
Shankar
Ideator II
8 years ago

Not able to restore Database for Version: 11.0 SP12; Build: 6920

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...
christopher_gillis's avatar
christopher_gillis
Community Manager
8 years ago
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