Hello, I install TeamCity. I need him to save his logs in MS SQL Server (I am using 2016 development). I downloaded and put the sqljdbc42 file in the lib> jdbc folder by entering authentication data (I need sql auth, but I can use regular windows auth), after clicking on the Proceed button, TC tries to create a database, it takes about 3-5 minutes and then it gives an error that it cannot connect to my server (it is local), I also tried to connect to the database on a remote server, but I get the same result enter image description here

The TCP / IP connection to the host DESKTOP-UPIKOD7, port 1433 has failed. Error: "Connection refused to connect. Verify the connection properties. . " (after 10 attempt (s); total time spent waiting 146341.758 ms; driver version 4.2.6420.100; java.version = 1.8.0_66; jdk.tls.client.protocols = []; jdk.certpath.disabledAlgorithms = [MD2, RSA keySize <1024]; jdk.tls.disabledAlgorithms = [SSLv3, RC4, DH keySize <768])

SQL exception: The TCP / IP connection to the host DESKTOP-UPIKOD7, port 1433 has failed. Error: "Connection refused to connect. Verify the connection properties. . " (after 10 attempt (s); total time spent waiting 146341.758 ms; driver version 4.2.6420.100; java.version = 1.8.0_66; jdk.tls.client.protocols = []; jdk.certpath.disabledAlgorithms = [MD2, RSA keySize <1024]; jdk.tls.disabledAlgorithms = [SSLv3, RC4, DH keySize <768])

Help please solve this problem.

    2 answers 2

    When I also put it about, like many others. I even have a lot of mate left about this in the file with comments on installation steps. It turned out to be easier to choose an internal database, then you can switch to MS SQL. The third stage will allow you to go to the Windows authentication, if you are sitting under AD.

    upd: By the way, I remember there were jumps with the connection string too. Here is an example of how it should look like:

    connectionUrl=jdbc:sqlserver://ServerName\\sqlInstance:1433;databaseName=TeamCity;integratedSecurity=true

    The ..\ProgramData\JetBrains\TeamCity\config\database.properties file is located: ..\ProgramData\JetBrains\TeamCity\config\database.properties

    If you rummage and there is time available, you can try to get out of your situation purely by the line. Honestly, I don’t remember why it didn’t work then, maybe the new versions have fewer problems.

    • Thanks, I will try. I hope something will turn out - simply good

    Hello again. the solution to the problem was hidden in the disconnected TCP service, you can read more about solving this problem https://blog.jayway.com/2014/08/08/installing-configuring-teamcity-on-windows-with-ms-sql-server/