Error: [Microsoft][ODBC SQL Server Driver][SQL Server] The UPDATE permission was denied on the object 'USERS', database '[database name]', schema 'dbo'. Native error: 229 when running Supervisor Reset Utility

When using the Supervisor Password Reset Utility, you may receive the following error:
  • "Run-time error '-2147211486 (80042722)': General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] The SELECT permissions was denied on the object 'USERS', database '[database name]',schema 'dbo'. Native error: 229 [Microsoft][ODBC SQL Server Driver][SQL Server] The UPDATE permission was denied on the object 'USERS', database '[database name]', schema 'dbo'. Native error 229"
We are currently evaluating this issue and will update this article when we have more information.

Alternative Solutions:
  1. Run the Supervisor Password Reset Utility on the Blackbaud Management Console server while logged on with Windows account that has local administrator rights
  1. If using a full version of SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014, ensure that you are logged onto the computer or server with a Windows account that has at least db_owner rights to The Raiser's Edge database.  (NOTE: Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.) 

Environment

 Raiser's Edge
 7.95

Was this article helpful?