CODEWITHSUNDEEP
azureazure-sql-databaseappveyor
Abdel Rodriguez Solis
Abdel Rodriguez Solis

Reputation: 41

Deploy Sql Database Project to Azure with appveyor failure

I have the next error when I deploy a Sql Database Project with Appveyor to Azure:

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

So, in this article Can't deploy Sql Database Project to Azure recommend add to Azure SQL Firewalls all the ip address allowed for Appveyor, but I still received the same error , what other thing may cause this issue?

Upvotes: 1

Views: 70

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15694

I hope you have created your Azure SQL Database logical server as explained here, please use the "Server Admin Login" credentials on your connection string. It seems Appveyor requires access to the master database and the Server Admin Login has all required permissions.

Upvotes: 1

Related Questions