TIBCO Spotfire Server configuration tool fails to open with the error "Could not establish contact with the database: Login failed for user 'domain\username'".

TIBCO Spotfire Server configuration tool fails to open with the error "Could not establish contact with the database: Login failed for user 'domain\username'".

book

Article ID: KB0077214

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

When trying to open the TIBCO Spotfire Server configuration tool (see Opening the configuration tool for more details) the following error gets logged even though the Spotfire Server is up and running. From the tools.log: 
ERROR 2019-08-27T11:39:56,149-0400 tools.confui.ConfigUiModel: Could not establish contact with the database: Login failed for user 'mydomain\myuser'. ClientConnectionId:041327e7-c895-448b-b53e-ec4283a422cd
ERROR 2019-08-27T11:43:02,148-0400 tools.confui.ShowBootstrapPanel: Could not extract site from database using the information in the bootstrap file
com.spotfire.server.tools.confui.ConfigUiException: Error determining the site for server 46c495cf-a442-4f1c-84cc-702cd4cac93a
	at com.spotfire.server.tools.confui.ShowBootstrapPanel.getSite(ShowBootstrapPanel.java:187) ~[spotfire-tss-tools.jar:?]
	at com.spotfire.server.tools.confui.ShowBootstrapPanel.readBootstrap(ShowBootstrapPanel.java:148) [spotfire-tss-tools.jar:?]
	at com.spotfire.server.tools.confui.ShowBootstrapPanel.<init>(ShowBootstrapPanel.java:99) [spotfire-tss-tools.jar:?]
	at com.spotfire.server.tools.confui.BootstrapTab.useExistingBootstrap(BootstrapTab.java:399) [spotfire-tss-tools.jar:?]
	at com.spotfire.server.tools.confui.BootstrapTab.tryUsingExistingBootstrap(BootstrapTab.java:465) [spotfire-tss-tools.jar:?]
	at com.spotfire.server.tools.confui.ConfigurationFrame.<init>(ConfigurationFrame.java:88) [spotfire-tss-tools.jar:?]
	at com.spotfire.server.tools.confui.ConfigurationMain$2.run(ConfigurationMain.java:69) [spotfire-tss-tools.jar:?]
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) [?:1.8.0_212]
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758) [?:1.8.0_212]
	at java.awt.EventQueue.access$500(EventQueue.java:97) [?:1.8.0_212]
	at java.awt.EventQueue$3.run(EventQueue.java:709) [?:1.8.0_212]
	at java.awt.EventQueue$3.run(EventQueue.java:703) [?:1.8.0_212]
	at java.security.AccessController.doPrivileged(Native Method) [?:1.8.0_212]
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74) [?:1.8.0_212]
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:728) [?:1.8.0_212]
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) [?:1.8.0_212]
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) [?:1.8.0_212]
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) [?:1.8.0_212]
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) [?:1.8.0_212]
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) [?:1.8.0_212]
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) [?:1.8.0_212]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'mydomain\myuser'. ClientConnectionId:dff1e55c-119b-43ac-8bbd-a88fb7678e2e
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:254) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:258) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:104) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$1LogonProcessor.complete(SQLServerConnection.java:4488) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:4773) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3581) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:81) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:3541) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7240) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2869) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2395) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2042) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1889) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1120) ~[sqljdbc4.jar:?]
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:700) ~[sqljdbc4.jar:?]
	at com.spotfire.server.util.sql.DriverWrapper.connect(DriverWrapper.java:69) ~[spotfire-server.jar:?]
	at com.spotfire.server.util.sql.PoolingDataSource.createStandardConnection(PoolingDataSource.java:1089) ~[spotfire-server.jar:?]
	at com.spotfire.server.util.sql.PoolingDataSource.createStandardConnection(PoolingDataSource.java:1075) ~[spotfire-server.jar:?]
	at com.spotfire.server.util.sql.PoolingDataSource.createConnection(PoolingDataSource.java:1071) ~[spotfire-server.jar:?]
	at com.spotfire.server.util.sql.PoolingDataSource.createAndInitConnection(PoolingDataSource.java:869) ~[spotfire-server.jar:?]
	at com.spotfire.server.util.sql.PoolingDataSource.getConnection(PoolingDataSource.java:722) ~[spotfire-server.jar:?]
	at com.spotfire.server.tools.confui.ShowBootstrapPanel.getSite(ShowBootstrapPanel.java:178) ~[spotfire-tss-tools.jar:?]
	... 20 more
ERROR 2019-08-27T11:43:03,855-0400 tools.confui.ConfigUiModel: Could not establish contact with the database: Login failed for user 'mydomain\myuser'. ClientConnectionId:a789be71-53a5-4cc0-b005-11d336a21730

 

Issue/Introduction

This article will help you resolve the issue if the TIBCO Spotfire Server configuration tool fails to open with the error "Could not establish contact with the database: Login failed for user 'domain\username'".

Resolution

This issue occurs when you are using Integrated windows authentication on Microsoft SQL server database (see Setting up the Spotfire database (SQL Server with Integrated Windows authentication) for more details). If the user trying to launch the TIBCO Spotfire Server configuration tool does not have sufficient access to the Spotfire database, then the above error is seen in the tools.log.

To resolve the issue, ensure the user logged on who is trying to launch the configuration tool has db_owner permissions to the Spotfire Server database.
 

Additional Information

Doc: Opening the configuration tool Doc: Setting up the Spotfire database (SQL Server with Integrated Windows authentication)
Powered by Wolken Software