CODEWITHSUNDEEP
sql-server-2012connection-stringflyway
DaveN59
DaveN59

Reputation: 3718

What is the correct syntax for a Flyway connection string to SQL Server?

Running SQL Server 2012 Express on a remote machine, trying to get Flyway up and running. I have a database on pcesqldev.pce.local called Hawk (dbo.Hawk, if that matters) that I want to connect to, and the template from the config file looks like this:

SQL Server        : jdbc:jtds:sqlserver://<host>:<port>/<database>

Note, this is different from other jdbc connection strings I have used with other products - most of them do not include the jtds portion and do include the instance name.

Here's a few connection strings that I have tried, all of which failed:

What am I missing? There must be something obvious, but I can't see it.

Before anybody asks, yes we do have TCP access to the database enabled and it is using port 1433.

Upvotes: 11

Views: 10314

Answers (4)

Pedro Junior
Pedro Junior

Reputation: 99

My problem was solved starting the service "SQL Server Agent (SQLEXPRESS)"

Steps:

  • Windows + R -> It'll open "Run" window
  • Type "services.msc" without double quotes ("")
  • Search for SQL Server Agent service
  • Right click over "SQL Server Agent" and go to Properties
  • Change "Startup type" to "Automatic" and apply the configuration
  • After clicked over "Apply" button, it'll enable "Start" button, click over this button
  • After the service has been started, try to execute flyway again

Image Example

Upvotes: 0

Damien Sawyer
Damien Sawyer

Reputation: 5907

This did my head in for a bit.

The connection string which I used was this (passed as parameters to flyway on the commandline).

Note also that the mydatabasename needed to already exist.

./flyway migrate -url=jdbc:jtds:sqlserver://localhost:1433/mydatabasename -user=myuser -password=mypassword -baselineVersion=269 -baselineDescription="Base version" -outOfOrder=true -baselineOnMigrate=

A piece that was missing though was that I wasn't running SQL Server Browser and possibly didn't have TCP set up correctly:

From the SQL Server section here. After the installation is complete, enable TCP/IP:

Launch the Sql Server Configuration Manager Go to SQL Server Network Configuration -> Protocols for SQLEXPRESS Enable TCP/IP TCP/IP Properties -> IP Addresses -> IPAll TCP Dynamic Ports: blank TCP Port: 1433 Then enable remote access:

Launch the Sql Server Configuration Manager SQL Server Services -> SQL Server Browser -> Properties -> Service Tab Start Mode: Automatic OK SQL Server Browser -> Start SQL Server -> Restart

Upvotes: 3

tbonz
tbonz

Reputation: 1127

This one got me, and there was not many answers out there on how to format a connection string with an instance name.

Here's what worked for me:

flyway.url=jdbc:jtds:sqlserver://<host>:<port>/<database>;instance=<instance_name>

Upvotes: 10

kamil-mrzyglod
kamil-mrzyglod

Reputation: 4998

In case anyone's problems, the correct connection string is as follows:

flyway.url=jdbc:jtds:sqlserver://SERVER_INSTANCE_NAME:1433/DB_NAME

It took me some time to realize that, but maybe it will be helpful for someone :)

Upvotes: 5

Related Questions