Hello TeamCity friends,
Our company is trying out TeamCity for CI builds and have installed version 7.1.3 on a Server 2008 R2 machine. So far we've been able to create, configure and build projects using TC and local database, but now we want to connect TC to a SQL db going forward. We've followed the instructions here but have had no luck so far connecting TC to our SQL Server 2008 R2: http://confluence.jetbrains.com/display/TCD7/Setting+up+an+External+Database#SettingupanExternalDatabase-MicrosoftSQLServer
Here are my connection settings when using the JTDS driver:
And here are my connection settings when using the native JDBC driver:
However, I keep getting the same error when trying to connect: SQL query: connect SQL exception: Login failed for user
Both the SQL server and TeamCity server are on the same domain; and the DOMAIN/user account we're using to connect to SQL is the accout we're using to run the TeamCity service and is also the SQL admin & dbo. Also, I have SQL configured with mixed authentication mode (both Windows and SQL authentication)
Is there something wrong with my database.properties
file settings? What could be the issue?