Bamboo JDBC Connection to SQL Express

[Ryan Strope]

Trying to configure our Bamboo Server to use a SQL Server Express instance and the Custom Installation wizard just spins and returns to the Choose how you wish Bamboo to connect to your database

i've verified every setting from tcp/ip to varying the uri i'm using to identify the SQL Server instance

Nothing works

the Bamboo instance and the SQL Server Instance are on the same physical server

[Daniel Santos · Accepted solution]

Hello Ryan,

It could be a problem not related to the DB configuration as well.

This are the troubleshooting steps I probably follow:

1. Check the server logs
   Unix like:<Bamboo_Install>/logs/catalina.out
   Windows :<Bamboo_Install>/logs/bamboo-stdout.<DATE>.log
2. If the problem is related to the DB, please make sure:
   1. Your database was created following this document: Microsoft SQL Server - Atlassian Documentation
   2. Your connection string is something like:

      jdbc:sqlserver://localhost:1433;databaseName=<DB_NAME>

   3. Your SQL server has a supported version:
      Supported platforms - Atlassian Documentation
3. If the problem is different, please paste the error here

[Ryan Strope]

Turned out the Server that was setup for me to use had MS SQL Server 2017 installed so I just had to set the DB compatibility and everything was copacetic.

Thanks for the help