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.
Please sign in to leave a comment.
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?
Simply it doesn't work with windows autentification. With sql server autentification only.