If you’re getting "Database is not set in connection settings" when running Axxon PSIM, you must check the following aspects:
Run the idb.exe database update utility (Start → Axxon PSIM → Utilities or from the folder <Axxon PSIM installation directory>\Tools). Execute the database update.
- If the DB update is being executed with errors, run the SQL Server Management Studio (Start → Microsoft SQL Server 2014) and check the connection to DB with the same parameters that are specified in the idb.exe connection string.
If the connection is not being established, check the correctness of credentials being used for it. If the authentication is being executed using the Windows NT integrated security, you must check that the user is given access permissions to SQL Server. To do this, go to the SQL Server under the embedded administrator account.
You must also check the SQL Server Service is being run. You can do this in the SQL Server Configuration Manager utility (Start → Microsoft SQL Server 2014 → Configuration Tools) in the SQL Server Services section. If the connection to SQL Server is being established in the SQL Server Management Studio utility, it means the Axxon PSIM configuration database has been damaged. You need to remove it, recreate and configure the connection to it in the idb.exe utility. After doing this, you need to restore the database from backup copy as far as possible.