title: Build and publish visual studio database project from Jenkins
body: <p>I have been trying to setup Jenkins to build and publish a visual studio database project. I use the Windows batch command to build the solution using msbuild, which creates a dacpac file. However, when I try to publish using sqlpackage, it fails as Jenkins user doesn't have enough privileges on the database server. What's the right way to go about doing this from here? </p>
  
  <ol>
  <li>Change the 'Log On' user for Jenkins from local system account to a service account, that has enough privileges on the database server  (<a href="http://antagonisticpleiotropy.blogspot.com/2012/08/running-jenkins-in-windows-with-regular.html" rel="nofollow">As mentioned here</a>)</li>
  <li>Enter the credentials in plain text within Jenkins build process (I really would hate to do this)</li>
  </ol>
  
  <p>Or is there a cleaner way to handle this?</p>