Support FAQ: Manual installion of the DACPAC file
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:
Failed to Deploy DacPac via DacServices API:
server=localhost;Trusted_Connection=True; Could not deploy package. Unable to
connect to target server.
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.
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.
- Click on Browser Installation Files on installer
- Drill into \InstallationFiles\DacPac
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