Microsoft SQL Server issues

Sometimes there may be an error when updating a database schema from one release to another. This relates to the wrong database being picked up by the SQL Server when the Database Setup Wizard is trying to upgrade the schema. SQL Server may connect to the master database instead of the default database.

Check these in the Microsoft SQL Server DSN Configuration dialog boxes:

  • Ensure that the Connect to SQL Server to obtain default settings for the additional configurations options check box is not selected.
  • Ensure that the Change the default database to check box is clear.