SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm trying to deploy sql server database thought CMD with msbuild (it works fine from VS). This is the command I'm using:
msbuild "Database Services\Database Services.sqlproj" /t:deploy /p:TargetConnectionString="TEST05,123;Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False" /p:TargetDatabase="test_fsdb"
but I'm getting the below exception:
error MSB4018: The "SqlDeployTask" task failed unexpectedly. [C:\project\Database Services\Database Services.sqlproj]
error MSB4018: System.ArgumentException: Keyword not supported: 'TEST05,123;integrated security'. [C:\project\Database Services\Database Services.sqlproj]]
What does this error means? I don't understand which argument causing the issue
The Data Source was missing from the TargetConnectionString:
TargetConnectionString="Data Source=TEST05,123;Integrated Security=True;Trusted_Connection=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False"