CODEWITHSUNDEEP
sql-servervisual-studio-2015sql-server-data-tools
Ravindra Kumar Challagandla
Ravindra Kumar Challagandla

Reputation: 178

Not able to deploy to SQL Server using DacPac

I am not able to deploy a dacpac to SQL Server 2016. There is no issue with username and password.

Error says 'Could not deploy package. Unable to connect to master or target server 'xxxx'. You must have a user with the same password in master or target server 'xxxx'.

SQL server version is shown below.

enter image description here

Visual studio Version - 2015 Community Version. Visual Studio SSDT Version - 14.X

Please help, thanks in advance.

Upvotes: 1

Views: 3854

Answers (2)

Sergey Barskiy
Sergey Barskiy

Reputation: 1803

Make sure your SSDT version (SQLPackage.exe) at least that high of a version as your SQL Server.

Upvotes: 1

tbfa
tbfa

Reputation: 509

Double check your .dacpac publish profile (xml). Ensure there is no information conflicting between what you are passing in as the username, password, connection string, etc. at runtime and what is in the xml file.

Upvotes: 0

Related Questions