Spotfire Server not accessible when using Integrated Authentication with Spotfire Database

Products	Versions
Spotfire Server	7.5 and higher

Description

The Spotfire Server might not come up when the database server is using Integrated Windows Authentication. Catalina log will be stuck at the following status for a long time, after every restart.
=====
04-Feb-2019 13:57:47.690 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
04-Feb-2019 13:57:47.706 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9080"]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9443"]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 529 ms
04-Feb-2019 13:57:47.706 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Spotfire]
04-Feb-2019 13:57:47.706 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/9.0.13
04-Feb-2019 13:57:48.753 INFO [main] org.apache.catalina.core.ApplicationContext.log Initializing com.spotfire.server.root.RootHttpMethodsFilter
04-Feb-2019 13:57:48.769 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\tibco\tss\10.0.1\tomcat\webapps\spotfire]
04-Feb-2019 13:57:53.503 INFO [main] org.apache.catalina.core.ApplicationContext.log 1 Spring WebApplicationInitializers detected on classpath
04-Feb-2019 14:04:46.866 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-80"]
04-Feb-2019 14:04:46.882 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
04-Feb-2019 14:04:46.897 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9080"]
04-Feb-2019 14:04:46.897 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9443"]
04-Feb-2019 14:04:46.897 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 544 ms
04-Feb-2019 14:04:46.897 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Spotfire]
04-Feb-2019 14:04:46.897 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/9.0.13
04-Feb-2019 14:04:47.976 INFO [main] org.apache.catalina.core.ApplicationContext.log Initializing com.spotfire.server.root.RootHttpMethodsFilter
04-Feb-2019 14:04:47.991 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\tibco\tss\10.0.1\tomcat\webapps\spotfire]
04-Feb-2019 14:04:52.757 INFO [main] org.apache.catalina.core.ApplicationContext.log 1 Spring WebApplicationInitializers detected on classpath
=====

Environment

All supported environments Spotfire Database: MS SQL Server

Resolution

This issue can be seen if the Spotfire server service is running through a Windows domain account that does not have permission to use the Spotfire database. When using the Windows Integrated Authentication, the account running the Spotfire Server service needs to have database owner access to the Spotfire database.

Note: When the database server is set up for Windows Integrated Authentication, the bootstrap will always use the account running the Spotfire Server service.

Issue/Introduction

Spotfire Server not accessible when using Integrated Authentication with Spotfire Database

Additional Information

Refer to the Spotfire Server Installation & Configuration manual for additional information

Welcome to "KB Articles"