Aras Community

Welcome to Aras Community Sign in | Join | Help
Aras Community
Please Also Visit the Project Site to Download Add-Ons and Solutions
Jump to Projects

Re: InnovatorDatabaseException on login after initial setup

  •  05-30-2007, 2:26 AM

    Re: InnovatorDatabaseException on login after initial setup

    Hello Deacon.

    It is very likely you need to run the following SQL for the restored DB
    EXEC sp_change_users_login 'Update_One', 'innovator', 'innovator'

    Explanation:

    The backup of the DB you restored was created on another database server instance. Thus SQL Server login innovator had some id associated with that. Let's say that was 123. In your new SQL Server instance SQL Server login innovator has some different id. Let's say it is 456. And even login names are the same restored DB cannot function properly without additional work. Thus :

    1) Ensure you have login innovator defined in your newly installed SQL Server.

    2) Run sql EXEC sp_change_users_login 'Update_One', 'innovator', 'innovator' to associate SQL Server login innovator with restored DB user innovator.

     

    Let us know if this helped you.

    Thank you.

    Filed under: ,
View Complete Thread
Powered by Community Server, by Telligent Systems