Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

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


Solution:

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

  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.
  Doc: Opening the configuration tool Doc: Setting up the Spotfire database (SQL Server with Integrated Windows authentication)

Related articles