Error: Startup Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver]The DELETE permission was denied on the object 'LOCKCONNECTIONS', database '[Name]', schema 'dbo'. Native error: 229 Main Startup Step: CBBStartSeq.Startup - when using Citrix

When logging into The Raiser's Edge using Citrix, a user may intermittently receive the following error:  
  • Error: Startup Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE permission was denied on the object 'LOCKCONNECTIONS', database '[Name]', schema 'dbo'. Native error: 229 Main Startup Step: CBBStartSeq.Startup Start Sequence Step: AddUserToLockFile

Download and run the ClearOrphans script and then schedule it as a job in SQL Server to run at your preferred interval (Example:  every 30 minutes).

Please consult with a qualified SQL Server administrator or with Microsoft regarding how to create a scheduled job in SQL Server. For more information, see Microsoft's article How to: Schedule a Job (SQL Server Management Studio).
NOTE:  We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing resolutions from these websites.

Environment

 Citrix

Was this article helpful?