1

We want to deploy Azure database which is in git source control in Visual Studio Online (VSO) to be deployed to the Azure Database. The script is in SSDT which I can deploy using my local Visual Studio IDE locally.

When I try to publish the database using VSO it throws following:

    ....publish.sql (0, 0)
Unable to connect to target server.

Our VSO build definition looks as below.

enter image description here

Any idea?

Daniel Mann
  • 57,011
  • 13
  • 100
  • 120
activebiz
  • 6,000
  • 9
  • 41
  • 64

1 Answers1

3

In a similar thread, it turned out that the problem was the SQL server password not being saved. The poster did the following to resolve:

  1. Server Explorer
  2. Right click connection > Modify connection
  3. Tick Save Password
  4. Advanced..
  5. Security Section - Enter password here
  6. OK
  7. Test connection - good
  8. Re-run publish from the relevant DatabaseDeploy.publish xml file

Source post here for reference: Database project deploy fails in Visual Studio 2013

Cpt. Monac
  • 749
  • 3
  • 7