FIX1.04.00 · Released 10 August 2011
High Importance
FIXfinPOWER Connect
Released in
1.04.00
10 August 2011
  1. Opened25 Jul
  2. Closed25 Jul
  3. Released10 Aug
Article 9006 Job J007849

Upgraded SQL Server databases fail with permission error or new tables

Upgraded SQL Server databases may fail with a permission error similar to the one shown below:

The UPDATE permission was denied on the object 'AccountDisbursement', database 'finPOWERConnect_Test', schema 'dbo'.

To fix this problem, do the following from finPOWER Connect:
1. Open finPOWER Connect
2. From the Tools, Database menu, select Reset Database Permissions
3. Select the database that is causing permission errors and complete the wizard