Support FAQ: Manual installion of the DACPAC file

merlenette_jonesmerlenette_jones Member Advanced IT Monkey ✭✭✭
edited August 2016 in FAQs

Overview

A data-tier application (DAC) is a logical database management entity that defines all of the SQL server objects - like tables, views, and instance objects, including login - associated with a user's database. A DAC is a self-contained unit in SQL Server database deployment that enables data-tier developers and database administrators to package SQL Server objects into a portable relic called a DAC package - more commonly referred to as a DACPAC

There are times when a user will experience an issue where the installer will not load the DACPAC and fails to install the Cireson Portal Properly. This error typically occurs using SQL 2014. When installing the Cireson Portal upon completion the installer will throw and error as seen blow:

Error

Failed to Deploy DacPac via DacServices API: server=localhost;Trusted_Connection=True; Could not deploy package. Unable to connect to target server.
and
Failed to Populating Default Settings items ServiceManagement on localhost: Invalid object name 'SettingsItem'.

A screen shot below is a visual representation of the installer error and the error a user will receive when trying to launch the Portal


Very important note: The version of SQL Management Studio must be the same as the version of SQL you are trying to install the DACPAC to.

Troubleshooting

To get around the installer issue you will need to manually apply the DACPAC as outlined in the steps below and then re-run the setup so the database creates itself.

To begin:

-           Click on Browser Installation Files on installer


-          Drill into \InstallationFiles\DacPac


-          Copy that file to your SQL Server
-          Open SQL Management Studio

-          Right click on the ServiceManagement DB and choose Tasks -> Upgrade Data-tier Application


-          Go through the wizard pointing to the DACPAC file

-          Rerun the setup to install the portal

Sign In or Register to comment.