[NXP-10219] Support Microsoft's JDBC driver for SQL Server - Nuxeo Issue Tracker

XML

Word

Printable

Tags:
- Backlog
- sqlserver
Backlog priority:
1,000
Impact type:

Configuration format change
Upgrade notes:

Hide

To support XA using the Microsoft JDBC driver, some setup has to be done in the SQL Server itself. It is NECESSARY to follow the Configuration Instructions listed at http://msdn.microsoft.com/en-us/library/aa342335(v=sql.105).aspx

In particular, after the configuration, note that you must add your database user ('nuxeo' in this example) to proper role in order for him to execute XA statements:

USE master
EXEC sp_grantdbaccess 'nuxeo', 'nuxeo'
EXEC sp_addrolemember [SqlJDBCXAUser], 'nuxeo'

Some screenshots for the first part are visible at http://www.sqlserver-dba.com/2011/12/enable-xa-transactions-for-sql-server.html

Show
To support XA using the Microsoft JDBC driver, some setup has to be done in the SQL Server itself. It is NECESSARY to follow the Configuration Instructions listed at http://msdn.microsoft.com/en-us/library/aa342335(v=sql.105).aspx In particular, after the configuration, note that you must add your database user ('nuxeo' in this example) to proper role in order for him to execute XA statements: USE master EXEC sp_grantdbaccess 'nuxeo', 'nuxeo' EXEC sp_addrolemember [SqlJDBCXAUser] , 'nuxeo' Some screenshots for the first part are visible at http://www.sqlserver-dba.com/2011/12/enable-xa-transactions-for-sql-server.html

There are some changes needed to replace jtds with Microsoft's driver.

depends on

NXP-2093 Make relations work with MS SQL Server

is required by

NXP-10220 Update old table names used for MSSQL

NXP-10234 Support Azure's flavor of SQL Server