Web Server Configuration

If you plan to deploy the OLAP cube with the Blackbaud Data Warehouse, you must configure your web servers to enable OLAP options in Blackbaud CRM such as the OLAP Explorer and the OLAP database roles tab on the Reporting Data Mart page. Keep in mind that if you have multiple web servers, you must configure them all for the OLAP cube.

If you plan to deploy the OLAP cube with the Blackbaud Data Warehouse, you must configure your web servers to enable OLAP options in Blackbaud CRM such as the OLAP Explorer and the OLAP database roles tab on the Blackbaud Data Warehouse page. Keep in mind that if you have multiple web servers, you must configure them all for the OLAP cube.

Tip: If you don't plan to use the OLAP cube, you do not need to configure your web servers for OLAP. When you deploy the data warehouse, you can set the Deploy OLAP cube setting on the Edit Advanced Data Mart Settings screen to "False" in order to improve the performance of the ETL process and remove the need for Analysis Server.

SQL Server 2008 or SQL Server 2008 R2

SQL Server 2008 or SQL Server 2008 R2 are supported for Blackbaud CRM versions 3.0 and prior.

Install SQL Server 2008 version of ADOMD.NET.

Update the web.config file for binding redirect to access OLAP Explorer.

Within the <runtime> and <assemblyBindings> tags near the beginning of the web.config files on your web servers, add the following information within <dependentAssembly> tags:

<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
</dependentAssembly>
<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
</dependentAssembly>

Install SQL Server 2008 Analysis Management Objects for OLAP database roles.

SQL Server 2012

SQL Server 2008 in compatibility mode 110 is supported for Blackbaud CRM versions 2.93 through 4.0.

Install both the SQL Server 2008 and SQL Server 2012 versions of ADOMD.NET.

Update the web.config file for binding redirect to access OLAP Explorer.

Within the <runtime> and <assemblyBindings> tags near the beginning of the web.config files on your web servers, add the following information within <dependentAssembly> tags:

<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.0.0-10.0.0.0" newVersion="11.0.0.0" />
</dependentAssembly>
<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.0.0-10.0.0.0" newVersion="11.0.0.0" />
</dependentAssembly>

Install SQL Server 2012 Analysis Management Objects for OLAP database roles.

SQL Server 2014

SQL Server 2014 in compatibility mode 110 is supported for Blackbaud CRM version 4.0.

Install SQL Server 2014 ADOMD.NET.

Update the web.config file for binding redirect to access OLAP Explorer. Copy the entry from the web.config file on the database server and place it into the web.config files on your web servers.

Within the <runtime> and <assemblyBindings> tags near the beginning of the web.config files on your web servers, add the following information within <dependentAssembly> tags:

<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.0.0-11.0.0.0" newVersion="12.0.0.0" />
</dependentAssembly>

<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.0.0-11.0.0.0" newVersion="12.0.0.0" />
</dependentAssembly>

Install SQL Server 2014 Analysis Management Objects for OLAP database roles.

SQL Server 2016

SQL Server 2016 in compatibility mode 110 is supported for Blackbaud CRM version 4.0.

Install SQL Server 2016 ADOMD.NET.
Update the web.config file for binding redirect to access OLAP Explorer. Copy the entry from the web.config file on the database server and place it into the web.config files on your web servers.

Within the <runtime> and <assemblyBindings> tags near the beginning of the web.config files on your web servers, add the following information within <dependentAssembly> tags:
```
<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.0.0-10.0.0.0" newVersion="11.0.0.0" />
</dependentAssembly>
```
Install SQL Server 2016 Analysis Management Objects for OLAP database roles.

SQL Server 2019

SQL Server 2019 in compatibility mode 110 is supported for Blackbaud CRM version 4.0.

Install SQL Server 2019 ADOMD.NET.
Update the web.config file for binding redirect to access OLAP Explorer. Copy the entry from the web.config file on the database server and place it into the web.config files on your web servers.

Within the <runtime> and <assemblyBindings> tags near the beginning of the web.config files on your web servers, add the following information within <dependentAssembly> tags:
```
<dependentAssembly>
 <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" />
 <bindingRedirect oldVersion="9.0.0.0-10.0.0.0" newVersion="11.0.0.0" />
</dependentAssembly>
```
Install SQL Server 2019 Analysis Management Objects for OLAP database roles.