Flyway url connection to a Sql Server instance

• amns

  SSCrazy

  Points: 2628

  More actions

  February 11, 2016 at 4:22 am

  #315821

  Hi,

  I'm trying Flyway, but I' can't connect to Sql Server instance.

  Does anyone knows how to correctly configure connection to sql server?

  I'm using:

  flyway.url= jdbc:jtds:sqlserver://[serverName]:[myPortNumber];instance=[mySqlServerInstance];databaseName=[myDatabaseName];

  excluding the []

  I'm getting:

  ERROR: Unable to obtain Jdbc connection from DataSource (jdbc:jtds:sqlserver://[serverName]:[myPortNumber];instance=[mySqlServerInstance];databaseName=[myDatabaseName];) for user 'myUser': Network error IOException: Connection refused: connect

  Anyone knows how to configure it?

  Thanks in advance

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  February 11, 2016 at 4:28 am

  #1857957

  I don't know Flyway, but maybe this link can point you to the right connection.

  Did you already try to connect from your host to the SQL server without using Flyway (like using Powershell)?

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• amns

  SSCrazy

  Points: 2628

  More actions

  February 11, 2016 at 5:46 am

  #1857976

  It's solved.

  The connection string format is correct.

  The sql server instance to which I was trying to connect was stopped..