Spotfire Server not accessible when using Integrated Authentication with Spotfire Database
book
Article ID: KB0079063
calendar_today
Updated On:
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 =====
Issue/Introduction
Spotfire Server not accessible when using Integrated Authentication with Spotfire Database
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.