- The SQL Server BI services (SSIS, SSAS, SSRS) should be running under an account that has the required permissions to allow remote connections (i.e. "local system" or a service account in the local administration group).
- The msolap.dll file needs to be installed where the the data collection service runs. The installation will look for the file and if its not found will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft
| Newtablink |
|---|
| alias | SQL Server 2016 Feature Pack |
|---|
| url | https://www.microsoft.com/en-us/download/details.aspx?id=52676 |
|---|
|
(choose the SQL_AS_OLEDB.msi installer). - Microsoft SQL Server Shared Management Objects(SMO) needs to be installed. You can install the SMO by downloading the installers from the
| Newtablink |
|---|
| alias | SQL Server 2016 Feature Pack |
|---|
| url | https://www.microsoft.com/en-us/download/details.aspx?id=52676 |
|---|
|
(ENU\x64\SharedManagementObjects.msi and ENU\x64\SQLSysClrTypes.msi) . Run the SQLSysClrTypes.msi installer first.
|