Database Connection Setup errpr
Hello,
Login failed for user 'teamcity-sql'. ClientConnectionId:287ee400-4811-41b6-847f-02b843642553 (after 10 attempt(s); total time spent waiting 542.841 ms; driver version 6.0.8112.100; java.version=1.8.0_151; jdk.tls.client.protocols=[]; jdk.certpath.disabledAlgorithms=[MD2, MD5, SHA1 jdkCA & usage TLSServer, RSA keySize < 1024, DSA keySize < 1024, EC keySize < 224]; jdk.tls.disabledAlgorithms=[SSLv3, RC4, MD5withRSA, DH keySize < 768, EC keySize < 224]) SQL exception: Login failed for user 'teamcity-sql'. ClientConnectionId:287ee400-4811-41b6-847f-02b843642553 (after 10 attempt(s); total time spent waiting 542.841 ms; driver version 6.0.8112.100; java.version=1.8.0_151; jdk.tls.client.protocols=[]; jdk.certpath.disabledAlgorithms=[MD2, MD5, SHA1 jdkCA & usage TLSServer, RSA keySize < 1024, DSA keySize < 1024, EC keySize < 224]; jdk.tls.disabledAlgorithms=[SSLv3, RC4, MD5withRSA, DH keySize < 768, EC keySize < 224])
I have setup the db as described here: https://confluence.jetbrains.com/display/TCD10/Setting+up+TeamCity+with+MS+SQL+Server#SettingupTeamCitywithMSSQLServer-CreatededicateduserforTeamCitywithSQLserverauthentication
I tried working through a few manuals but nothing seems to work. I have the right credentials and did not change any default security features in windows.
I can successfully Telnet 1433 on localhost.
Any help will be greatly appreciated
Please sign in to leave a comment.
Hello Eran,
Successful telnet connection to localhost:1433 tells us nothing about the authentication -- it is merely an indication that an MS SQL Server instance is indeed listening for the incoming TCP connections. The "Login failed" message from TeamCity shows just the same: TCP connection was successful, but authentication failed.
Hi Andrey,
I have managed to solve the issue by re-installing, somehow it worked.
Thank you,
Hi Eran,
Glad to hear that.
Feel free to contact us should you have any questions.