Article Details
| Id: | 9006 |
| Product: | finPOWER Connect |
| Type: | FIX |
| Version: | 1.04.00 |
| Opened: | 25/07/2011 |
| Closed: | 25/07/2011 |
| Released: | 10/08/2011 |
| Job: | J007849 |
 High Importance |
|
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