Unfortunately, your text is pretty bad formatted and I don't understand it.
Currently, there's an issue with MSSQL driver (http://youtrack.jetbrains.com/issue/TW-34987) that if you don't enter all properties correctly from the first time, it doesn't allow you to connect, until you restart TC.
"Badly Formatted" - yeah, I know. All my nice formatting went out the window when I hit submit. Sorry.
I have tried changing the properties, then stopping and restarting the service. Still does not connect.
what does it say in teamcity-server.log and catalina.out?
We used the sqljdbc_4.0.2206.100_enu.exe driver dropping the sqljdbc_auth.dll into the TeamCity\jre\bin directory and the sqljdbc4.jar into ProgramData\JetBrains\TeamCity\lib\jdbc
The connection configuration was in the following location ProgramData\JetBrains\TeamCity\config\database.properties
# This is a sample configuration file for configuring TeamCity to use external database.
# To make it effective, copy it to the "database.properties" file and modify settings
# according to your environment.
# Do not modify this file, it will be overwritten on TeamCity server startup.
# See documentation at http://www.jetbrains.net/confluence/display/TCD5/Setting+up+an+External+Database
# Database: Microsoft SQL server (via jtds driver)
# The maximum number of connections TeamCity can open on database server.
# Specifies whether TeamCity should check each jdbc connection before use.
# It reduces the system performace but avoids cases when the system uses
# a connection that was closed by database server due to time out or this
# connection was broken at the previous operation.
This setup worked for us.
I ended up using the other (jdbc: jtds) driver. For some reason, that one worked without a hitch.