Deployment Error at Relational Step

Author: Joyce Zhou

Symptom

An HttpWebRequest_WebException_RemoteServer error happens at the Relational step during deployment. The error message is as below.

Resolution

Please install these SQL components on the Web Server. Please perform the following actions on the Web Server based on the version of SQL you are using:

If you are using SQL 2008 or SQL 2008 R2:

1. Install Microsoft® SQL Server® 2008 R2 Analysis Management Objects
2. Install Microsoft® SQL Server® 2008 R2 ADOMD.NET
3. Install Microsoft® SQL Server® 2008 R2 Native Client
4. Reboot after installation to allow components to register

If you are using SQL 2012 or SQL 2014 or SQL 2016:

1. Install Microsoft® SQL Server® 2012 Analysis Management Objects
2. Install Microsoft® SQL Server® 2012 ADOMD.NET
3. Install Microsoft® SQL Server® 2012 Native Client
4. Reboot after installation to allow components to register