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?
相关问题
- sql execution latency when assign to a variable
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
- SQL to Parse a Key-Value String
相关文章
- Entity Framework 4.3.1 failing to create (/open) a
- Code for inserting data into SQL Server database u
- Delete Every Alternate Row in SQL
- Linux based PHP install connecting to MsSQL Server
- SQL Azure Reset autoincrement
- How do we alias a Sql Server instance name used in
- Is recursion good in SQL Server?
- How can I convert a OLE Automation Date value to a
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.
I found that this is an permission issue. The user has to have administrative privileges to update the database using a dacpac.