Deploying a database using VSDBCMD.exe without using integrated security

Question

I am trying to deploy a Visual Studio Database Project (GDR R2) using VSDBCMD.exe utility. I can successfully deploy when the connection string uses Integrated Security, but when I switch to using Sql Server authentication, I get the following error:

Failed to import target MyCatalog model. Detailed message Operation "Reverse engineer" cannot continue because you do not have permission "Definition of permission" in the database "MyCatalog".

I can successfully deploy using Sql Server authentication when deploying through Visual Studio.

This uses the command that I run:

vsdbcmd
  /a:deploy 
  /dsp:sql 
  /dd- 
  /cs:"Data Source=localhost;Initial Catalog=MyCatalog;User ID=MyUserId;Password=MyPassword" 
  /script:C:\MyDbScriptFile.sql
  /manifest:C:\Database.deploymanifest         
  /p:DeploymentConfigurationFile=C:\Database.sqldeployment      
  /p:SqlCommandVariablesFile=C:\Database.sqlcmdvars

. , Integrated Security, .

Sql Server Profiler Visual Studio VSDBCMD.exe MyUserId. Visual Studio, , . . , , , , -.

, , Visual Studio.

.

Answer 1

. Visual Studio .