Db setup failed with error '' This Sql Transaction has completed; it is no longer usable.''

Last Modified on 12/28/2021 4:40 pm EST

Symptom

When updating from OnGuard 6.3.249 to 6.4.500 with SQL 2005 server, Database Setup fails with error:
This Sql Transaction has completed; it is no longer usable.

Resolution

The Lenel user in SQL does not have 'serveradmin' rights. Grant 'serveradmin' rights to correct this issue.

Applies To

OnGuard 2010 (6.4.500)
SQL Server (All versions)

Additional Information

How would you rate this article?

Db setup failed with error '' This Sql Transaction has completed; it is no longer usable.''

Symptom

Resolution

Applies To

Additional Information

Related Articles