Cannot connect to SQL Server.

I set all according to instruction for integrated security:

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 into C:\ProgramData\JetBrains\TeamCity\config with a string


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.

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?

Comment actions Permalink

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


Please sign in to leave a comment.