msbuild deploy command fails with exception

Question

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

Have you tried starting the TargetConnectionString with Server=? — AlwaysLearning
– AlwaysLearning, Commented Apr 7, 2021 at 9:27

arielma · Accepted Answer · 2021-04-07 09:35:49Z

1

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"

answered Apr 7, 2021 at 9:35

arielma

1,4282 gold badges17 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

msbuild deploy command fails with exception

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related