Update TeamCity DB location to server with instance

Hello, im running TeamCity 2017.2.1. we just upgraded to SQL Server 2016 and when i update my database.properties file, i receive a failed login error.

This account has permissions to the server, the instance and the database (this is our build server also running TFS and the TFS DB is in the same instance, which works fine)

 

here is the error message, i changed the account name for the post:

Login failed for user 'domain\account'. ClientConnectionId:b59dbbe9-6ef9-462a-92cf-e54f897e0a30 (after 10 attempt(s); total time spent waiting 832.857 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 'domain\account'. ClientConnectionId:b59dbbe9-6ef9-462a-92cf-e54f897e0a30 (after 10 attempt(s); total time spent waiting 832.857 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])

 

here is the database.properties file, i changed the connection string:

#Wed Mar 29 09:10:44 EDT 2017
connectionUrl=jdbc:sqlserver://dbserver\\instancename:1433;databaseName=TeamCity;integratedSecurity=true

 

I have reinstalled several times, though using a backup. I really dont want to have to set up all my builds from scratch.

 

 

 

 

0

Please sign in to leave a comment.