Connecting to sqlserver using kotlin and gradle


I had difficulty connecting to MS SQL Server in kotlin using gradle earlier today. I do not know if it is appropriate to post this here but I worked out a solution and thought that it might be helpful to others.

As a starting point, because of earlier issues, I had removed all instances of Java greater than version 8 from my computer.

First, relevant sections of build.gradle

repositories {

sourceCompatibility = 1.8
targetCompatibility = 1.8

dependencies {
    compile group: '', name: 'mssql-jdbc', version: '6.2.1.jre8'

For the actual (kotlin) code (imports first)

import java.sql.*

For setting up the connection:

val dbURL = "jdbc:sqlserver://sssssss\\ssss;user=uuuuuuuuu;password=pppppp"
val connection: Connection = DriverManager.getConnection(dbURL)


  • sssssss\ssss is the identifier for the server provided to be my our IT department
  • uuuuuu is my userid
  • pppppp is my password (which I should not have included directly in the code)