3 comments
Comment actions Permalink

Sorry for the delay with http://devnet.jetbrains.com/message/5497909. I've answered.
Briefly, check the JDK version TeamCity starting on.

Best regards,

Leonid Bushuev

0
Comment actions Permalink

Just want to update this in a more detailed way, since I just upgraded TeamCity again and had the same problem!

What seems to happen is that when you upgrade TeamCity, it puts a 32-bit JRE in the teamcity\jre folder.  If your old version had a 64-bit jre there, it will be overwritten with the 32-bit one!  This will cause Integrated Security to MS SQL to stop working with an error that does not say anything about 32-bit / 64-bit.

To solve this I copied C:\Program Files\Java\jre7 (which is a 64-bit JRE I had downloaded from Oracle) into teamcity\jre, which overwrote the 32-bit jre with the 64-bit one, and restarted all the TeamCity services.

So all the steps required to get integrated security to work are:
Copy C:\Program Files (x86)\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc4.jar to teamcity\.BuildServer\lib\jdbc
Copy C:\Program Files (x86)\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\auth\x64\sqljdbc_auth.dll to C:\Windows\System32
Copy C:\Program Files\Java\jre7 (which must be a 64-bit jre) to teamcity\jre
In teamcity\.BuildServer\config\database.properties, set:
connectionUrl=jdbc:sqlserver://myServerName:1433;databaseName=TeamCity;integratedSecurity=true

Restart the TeamCity services

0
Comment actions Permalink

Hello Tzadik,

Thank you for update.

You expierenced known issue TW-28404. You're welcome to watch/vote for it.

Best regards,

0

Please sign in to leave a comment.