I am new to VSTS and I am trying to get a msbuild task to publish a SQL Server project using a publish profile.
The build task works if I use a local agent but fails when I try with a Microsoft-hosted agent (Hosted VS2017), error below.
Is there something I should add to the firewall rules for the database server?
I am using Integrated Security=False and the server is Microsoft SQL Server Developer (64-bit) ver. 13.0.4001.0.
msbuild arguments: /t:Publish /p:SqlPublishProfilePath=Archive.publish.xml
error: D:\a\1\s\TestSolutions\Application\Archive\bin\Debug\Archive.publish.sql(0,0): Error Deploy72002: Unable to connect to target server '{theserver}'. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server.
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)