How to Deploy Community Connectors on a MicroStrategy IIS Web Server with a 401 Unauthorized Error

Description

If a Strategy environment is set up with an IIS Web server, you may encounter a 401 Unauthorized error when deploying a Community Connector.

Why is this happening? 

When a Community Connector is deployed, your Strategy Web server host is added into a whitelist and the connector is then added to Strategy Web. When this error appears, it means the process of adding your Web server host to the whitelist has failed.
 

Solution

To utilize the Community Connectors, you can manually add your Strategy Web server hostname to the whitelist.txt file.

• From the Community Connectors Gallery, download a Community Connector as an .mstrcc file.
• Open Strategy Web, and click Add External Data > Add Connector.
  

• Upload the .mstrcc file and click Add.
• Navigate to your Community Connector server, which is usually in Tomcat in the file path [Tomcat]\webapps\CommunityConnectors\WEB-INF\whitelist.txt.
• Add a new line and enter your Strategy Web server hostname.
  

For more information on Community Connectors, see MicroStrategy Community Data Connectors.