"Server unavailable for transaction end" - FIX

[Sean]

If you are getting:

transaction failed
server unavailable for transaction end

or similar.. then you may have SQL NT Fibers turned on SQL Server. Disable them, and try again.

I got this any tracked it down to XML stored procedures not permitted with NT FIbers enabled.

Hope this helps someone else...

Sean

[trm]

Thanks - I wish this was easier to find! This fixed exactly the problem I was experiencing w/ a new Vault installation.

-- michael

[cside]

how do you do this?

[jclausius]

Use the following query in a Query Tool:

Code: Select all

sp_configure 'lightweight pooling', 0
RECONFIGURE
GO

or

Disable the "Use Windows NT Fibers" option on the Processor tab within the Database Properties Page within SQL Enterprise Manager.

[jclausius]

Please note - You can verify this error by checking Vault Server's error log.

As with any unrecognized error you encounter, the Server log will contain more information about the problem. In the case of Sean's post, the sgvault.log will contain a message regarding XML procedures not allowed when SQL Server is using Windows NT Fibers.