All geek questions in one place

What is "DacInstance with the specified instance instance does not exist" (Microsoft SQL Server, 36004)?

I am trying to update a remote SQL Server 2012 database database using dacpac, but I get the following message: DacInstance with the specified instance instance_id does not exist. (Microsoft SQL Server, 36004) . I tried to search the Internet, but could not find anything. Any ideas?

enter image description here

+6
source share
2 answers

I myself ran into this problem. I hunted through User Mapping for my login, adding the db_owner, db_securityadmin membership for all relevant databases. No help.

In particular, it was necessary to add the sysadmin server role for the user. After that, my dacpacs were able to deploy successfully.

+5
source

I found this to be a resolution issue. The user must have administrative privileges to update the database using dacpac.

0
source

Source: https://habr.com/ru/post/955322/

More articles:


All Articles