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

This topic contains 2 replies, has 2 voices, and was last updated by  Shankar 2 months, 3 weeks ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #11376

    Shankar
    Participant

    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.

     

     

     

    #11392

    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

    #11463

    Shankar
    Participant

    Thank you Christopher

    Its working and it helped me a lot.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.