Home → Questions →

Unable to deploy to Sql Azure during build

• Edit

chrisdunn_03

29 Jan, 2018 02:22 PM

See the project https://ci.appveyor.com/project/dungimon/healthcheck

I have configured the project to deploy the dacpac build artifact to sql azure and have configured the deployment settings accordingly.

The build fails with the error message:

Error publishing database: Could not deploy package. Unable to connect to master or target server 'health-check'. You must have a user with the same password in master or target server 'health-check'.

The connection string includes the username and password for a user with full administrative access to the server + database.

I have setup the firewall rules on sql azure to allow access from your build and deploy agent as documented here: https://www.appveyor.com/docs/build-environment/#ip-addresses

See attached a screenshot of my sql azure firewall settings.

I have tested the ssdt publish locally from visual studio using the same connection string + user/pw and it published successfully. I have successfully published in Visual Studio 2017 from both versions 15.5.1 and 15.5.5 using SQL server data tools version 15.5.1. The project is configured to build using Visual Studio 2017.

Enabling verbose build logs doesn't give any additional information as to what is causing this.

Have the build agent IP addresses changed? am I missing an address from the firewall?

Any help would be much appreciated.

• sql_server_fire_wall_rules.png 8.29 KB

1. 1 Posted by Ilya Finkelshte... on 29 Jan, 2018 08:00 PM

   

   I believe this is related to this still opened issue. Sorry, we fix it in next couple of weeks.

   • Edit

2. 2 Posted by chrisdunn_03 on 31 Jan, 2018 02:05 PM

   

   Ok thanks for the response, I've disabled the ssdt deploy for the meantime.

   • Edit

3. Ilya Finkelshteyn closed this discussion on 25 Aug, 2018 02:26 AM.