title: Build Failed on Continuous integration with SQL Server Data Tools and Team Foundation Server
body: <p>I am trying to implement this idea <a href="https://www.sqlshack.com/continuous-integration-sql-server-data-tools-team-foundation-server/" rel="nofollow noreferrer">https://www.sqlshack.com/continuous-integration-sql-server-data-tools-team-foundation-server/</a> and I am getting this error:</p>
  
  <blockquote>
    <p>Error Deploy72002: Unable to connect to master or target server 'DatabseTest'. You must have a user with the same password in master or target server 'DatabaseTest'.</p>
  </blockquote>
  
  <p>I did the idea in a very simple way I created a database for the test in a Development server (just one table with an ID and Name columns), I created a database project on the visual studio, I create a script to insert a few rows in the only table in the database. Then I create a publish profile, I added the connection to the 'DatabaseTest' in the 'DEV' server, the user I am using for the access to the database is a user with admin permissions, the script associated with the publish profile is the only script in the solution the one for insert the rows. I made the check in and I created a build definition. I am trying to make the project build successfully, so I just add a Build Solution Task, in the MSBuild Arguments this is what I am passing:</p>
  
  <pre><code> /t:build /t:publish /p:SqlPublishProfilePath=Database_Testing_Profile.publish.xml
  </code></pre>
  
  <p>And I am getting the error from the beginning of the question.</p>
  
  <p>Can someone please give an idea, about what is the problem??</p>
  
  <p>Thank you.</p>