Database Connection Setup errpr

Hello,

I am using CIS Microsoft Windows Server 2016 Benchmark 1.0.0 Level 2 on EC2 with ms-sql express 2016. When coming to setup Teamcity 2017.2 I receive the following error:

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

0
3 comments
Avatar
Permanently deleted user
Official 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.

  1. What type of authentication do you (intend to) use (SQL Server or Windows Integrated)?
  2. Can you confirm you can log in to the database instance by any other means (e. g.: SQL Server Management Studio)?

 

Avatar
Permanently deleted user

Hi Andrey,

 

I have managed to solve the issue by re-installing, somehow it worked.

 

Thank you,

0
Avatar
Permanently deleted user

Hi Eran,

 

Glad to hear that.

Feel free to contact us should you have any questions.

0

Please sign in to leave a comment.