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.
Failed to Populating Default Settings items ServiceManagement on localhost : Invalid object name 'SettingsItem'.
The screenshot below is a visual representation of the installer error and the error a user will receive when trying to launch the Portal
Note: The versionof 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
Locate \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