I'm trying to upgrade a remote SQL Server 2012 database using a dacpac, but I'm getting the following message: DacInstance with the specified instance_id does not exist. (Microsoft SQL Server, 36004). I tried to search on the internet but couldn't find anything. Any ideas?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
I just encountered this problem myself. I hunted through the User Mapping for my login, adding db_owner, db_securityadmin role memberships for all relevant databases. No help.
Specifically, it was necessary to add the "sysadmin" server role to the user. After doing this, my dacpacs were able to deploy successfully.
回答2:
I found that this is an permission issue. The user has to have administrative privileges to update the database using a dacpac.