Cannot connect to SQL Server.

Hello,
I set all according to instruction for integrated security:
http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database

put sqljdbc4.jar into C:\ProgramData\JetBrains\TeamCity\lib\jdbc   (from TEAMCITY_DATA_PATH + lib\jdbc )
put sqljdbc_auth.dll from sqljdbc_home /enu/auth/x64/sqljdbc_auth.dll into C:\Windows\System32
put database.properties into C:\ProgramData\JetBrains\TeamCity\config with a string

connectionUrl=jdbc:sqlserver://srv;instance=sqlexpress;databaseName=TeamCity;integratedSecurity=true;

and on database connection setup TeamCity still returns error:

SQL error when doing: Taking a connection from the data source: This driver is not configured for integrated authentication.

I also tried to place sqljdbc_auth.dl directly to /bin where java is installed - no result. What else does he need? May be pray to him?
I use Windows server 2008 and java 7. TeamCity 8.1.5.

2 comments
Comment actions Permalink

In TeamCity logs there is

Current stage: Setup database connection (administrator login is required to proceed)

I set integrated security=true, which administrator login does it need?

0
Comment actions Permalink

Simply it doesn't work with windows autentification. With sql server autentification only.

0

Please sign in to leave a comment.