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
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
Confirm that the service account has access to the data source.
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"/>
Save the web.config file.
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.
Prompt - To prompt the user for credentials.
ServiceAccount - To 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 modeor Kerberosmode.
Additional Information
Doc: TIBCO Spotfire Web Player Installation and Configuration Manual > Data from External Sources