How to disable the prompt when using the Web Player to open a Spotfire analysis that has a data connector connection configured with Windows integrated authentication.

How to disable the prompt when using the Web Player to open a Spotfire analysis that has a data connector connection configured with Windows integrated authentication.

book

Article ID: KB0082267

calendar_today

Updated On:

Products Versions
Spotfire Web Player 7.0 and lower

Description

If an analysis uses a data connector connection that is configured to use Windows integrated authentication, then by default the user will be prompted for credentials when opening the report on the Web Player. This can be disabled by updating the data adapter settings in the Web Player's web.config file.

Issue/Introduction

How to disable the prompt when using the Web Player to open a Spotfire analysis that has a data connector connection configured with Windows integrated authentication.

Resolution

  1. In Internet Information Services (IIS), configure the Web Player application pool to use a custom service account.
    • Server Name > Application Pools > TIBCO Spotfire Web Player X.X.X Pool > Advanced Settings > Process Model > Identity
  2. Confirm that the service account has access to the data source.
  3. Edit the web.config file. In the <setting name="WebAuthenticationMode" serializeAs="Xml"> adapters setting, change the "mode" associated with the connector used in the analysis. Change it from this default:
         <adapter name="spotfire.SqlserverAdapter" mode="Prompt"/>
    to this:
         <adapter name="spotfire.SqlserverAdapter" mode="ServiceAccount"/>
  4. Save the web.config file.
  5. Restart the Web Player application pool or restart IIS.

 

Note: Several different authentication modes can be set for the various data sources. More information can be found in the Spotfire Web Player Installation and Configuration Manual. 

Valid modes are: 

  • WebConfig - To connect with credentials stored under Spotfire.Dxp.Web.Properties.Settings / DataAdapterCredentials in the web.config file.
  • Kerberos - To connect using Kerberos authentication. 
  • PromptTo prompt the user for credentials. 
  • ServiceAccountTo connect as the account used for running the application pool in IIS.
The prompt could also be disabled by configuring the data adapter to use WebConfig mode or Kerberos mode.

 

Additional Information

Doc: TIBCO Spotfire Web Player Installation and Configuration Manual > Data from External Sources
  • https://docs.tibco.com/pub/spotfire_web_player/7.0.0/doc/pdf/TIB_sfire_webp_7.0.0_installation.pdf