KB75768149: BackStage - Error: "Connection to Database failed. Reason Exeception : Schema for table not up to date"

Summary

The BackStage Database connection fails with the following error message:

Connection to Database failed.

Reason Exeception :

Schema for table not up to date

Symptoms

• When synchronizing the database in the BackStage Configure, the following error message appears:
  
• When opening Task History, the following error appears:
  

When creating a new database and add a new task to Task History the same problem exists.

Solution

These errors appear when the BackStage Databases are owned by "dbo" who is an "sa" user. Change the owner of the BackStage Databases from "dbo" to "admin".

Refer the following KB article on how to change the database owner: 

• Page:
  KB75768668: BackStage - Problem after updating Esko Software Suite 7 R3 to R4 in case of remote SQL 2005 server