Errors trying to install TeamCity onto Windows Server 2008 using SQL Server for the db

Hello, I'm trying to evaluate TeamCity as an alternative to TFS for our company. I was hoping for a smoother experience, but thus far - no.

After doing the installation of TeamCity 9.1.4, and then clicking "Finish" it brings up a browser with "TeamCity First Start"
I selected the database type: MS SQL Server
(I have installed SQL Server 2014 on a fresh installation of Windows Server 2008 R2 Standard)
When it complained the first time that "The MS SQL Server JDBC driver is not found in the
C:\ProgramData\JetBrains\TeamCity\lib\jdbc directory.", I downloaded sqljdbc_4.2.6420.100_enu.exe from Microsofte's website and installed that, and clicked "Refresh JDBC drivers"  and now it says "Loaded MS SQL Server JDBC driver version 4.0"

I entered for "Database instance name:" my SQL Server instance-name "SQLSERVER", left the other fields on that page blank, chose Windows Authentication...
and it gives me this error:  "Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class librasry, which provides support for JDBC 4.0"

I am not a Java expert. I do .NET, and have no idea why it is complaining about JRE version 1.8 (was there ever such a version? I installed JRE versions 7 and 8 onto this box) and why would this installer not give some clear directions during installation? What does one do with this mess?  How do I use "the sqljdbc4.jar class library" - do I need to search for that file, and do something with it?  This is one reason I avoid Java programming, everything is so unclear.

Is this not a supported combination (C# .NET development, or Microsoft SQL Server) ?

Your help would be appreciated - thank you.

James Hurst
1 (415) 816-8572
Norcross, GA

5 comments

Hi James,

Please do the follwoing:

  1. Download the MS sqljdbc package from the Microsoft Download Center and unpack it.
  2. Copy the sqljdbc4.jar from the just downloaded package into the
    TeamCity Data Directory/lib/jdbc
    directory. Proceed with the TeamCity setup.
0

Thank you for responding Alina. However, I had already placed that file after downloading it.  C:\ProgramData\JetBrains\TeamCity\lib\jdbc\ does contain sqljdbc4.jar.

I see that within that webpage that you provided a link to, it contains:

"If you use a named instance, you need to manually modify the <TeamCity Data Directory>\config\database.properties file and specify the instance name in the connection URL as follows:
connectionUrl=jdbc:sqlserver://<host>\\<instance_name>:1433;databaseName=<database_name>
"
However there is no such file. Is this implying that I should create a new text-file containing this?  That really should be made more explicit or correct.
What precisely should be entered for <host> - should that be "localhost", or perhaps the machine-name (this is a Windows 2008 R2 server virtual-machine, with machine-name "SourceServer").  ?


Do you have any other leads on how to get this to work?

jh

0

According to the error message:
"Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0"
the database driver you put to the <TC_DATA_DIR>/lib/jdbc is too old and doesn't support java 1.8. Please download the latest driver and replace sqljdbc4.jar with the new one from Microsoft.

The file

<TeamCity Data Directory>\config\database.properties should be automaticaly created using properties that you entered on "
Database connection setup". If there is no such file please enter create it manually.
Also if you select Windows authentication you should install sqljdbc_auth.dll from the driver package. Please see the details in this section.

If database is installed locally, then "localhost" can be used.

If the above recommendations does not help, then please attach teamcity-server.log file.
Sorry for the inconvenience.
0

The sqljdbc4.jar file that I downloaded and used, is the latest from that link that you provided (Microsoft's download site).

Java seems to be a rather messy ecosystem to try to use for implementation any desktop application like this. It's probably just my own inexperience with it - but, geez. I create .NET desktop applications for Windows, for which the user just runs the installer and .. it's ready to roll. Java seems like a massive headache!

Do you think a different database would serve better? SQL Server does not seem to really be supported by TeamCity.

Thank you for your help though,

JH

0

Hi James,

MS SQL is officially supported by TeamCity. Could you please attach zipped TeamCity server logs folder?

0

Please sign in to leave a comment.