Accpac Database Setup Error with MS SQL - MARS batch is still active

[blahlazer]

All,

I'm trying to set up Accpac 5.5A with Microsoft SQL Server but I am unable to create an Accpac database using the Database Setup utility. I'm using Microsoft SQL Server 2008 Enterprise and I have created a standard database named accsys in the SQL Server Management Studio. After creating the database, I've tried to create a new Accpac database entry in the Accpac Database Setup utility by clicking new, setting accsys as the database ID and "Microsoft SQL Server" as the database format. After filling in the database credentials on the "Edit SQL Server Database Profile" screen and hitting enter, I get:

"DBSETUP: Create applications table.

Database error (operation=CREATE-TABLE, error=3997)

[Microsoft][SQL Server Native Client 10.0][SQL Server]A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back. Please refer this error to our database administrator or see your database documentation for further asistance."

I've uninstalled Accpac and MS SQL Server several times with no luck. Any help would be appreciated.

Thanks

 

[Jay Converse]

Never seen it, but a quick Google tells you you shouldn't connect with MARS enabled.

 

[blahlazer]

I figured it out. I was missing the Accpac service packs and once I installed them, the error disappeared. I hope this helps someone out in the future.