VSTS Build + Azure Database
I'm trying to make a CI/CD pipeline for my database on VSTS and deploy it on an Azure SQL Server. But I'm stuck at the build process.
Here are the tasks I use :
- Setup a Shadow DB
- Build solution
- Copy Publish Artifact
Here are the variables used :
But at the second task (Build solution), I have an issue to connect to the Azure Database :
packages\ReadyRoll.MSBuild.188.8.131.5267\tools\ReadyRoll.Data.Schema.SSDT.targets(145,5): Error : An error occurred while attempting to verify your deployment scripts: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
The login/password are correct, I checked multiple times.
I tried the Hosted agent as well as a private agent (on my own machine) but I have the same error.
Can you help me with that ?