I'm trying to setup TC to connect SQL Serever (2008R2SP2) with Windows (integegrated) authentication as described here: http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database
TC is installed on Windows Server 2008R2 (x64) so I installed JDK x64 (1.7.25).
I install jdk driver and put appropriate sqljdbc_auth.dll into winodws/system32 as described in the docs.
I create a DB and .properties file with connection string (connectionUrl=jdbc:sqlserver://localhost:1433;databaseName=TeamCity;integratedSecurity=true).
I have succesfully migrated all data from internal DB to SQL DB with help of bin\maintainDB.cmd script.
But when I start TC (as Windows Service) I get the following error:
SQL error when doing: Connecting to MSSQL: This driver is not configured for integrated authentication.
I have the only guess that TC internally uses x86 JRE which isn't compatible with installed sqljdbc_auth.dll. But if so then how do you suppose it should work on x64 Windows ?