Web Viewer 12.1 Database Connection Cannot Be Established Websphere
book
Article ID: 129438
calendar_today
Updated On:
Products
Output Management Document ViewerOutput Management Web Viewer
Issue/Introduction
We are moving from SQL 2008 on Windows 2008 R2 Datacenter X64 Edition to SQL 2016 on Windows Server 2016 Datacenter Edition. We are getting 'Database connection cannot be established' error. Your supportability matrix lists Windows Server 2016 Standard as compatible with R12.1 with build 179. We have build 181 so that shouldn't be an issue. . We aren't getting to the new SQL server. TLSV1.2 only is set up in the registry
Environment
MS Windows 2016 Datacenter MS SQL Server 2016 Websphere 8.5.5.13. TLSv1.2 Java 1.8 Web Viewer 12.1 Build 181
Resolution
Here is what resolved the problem: 1) Upgrade to Java 1.8 (Java 1.7 does not work no matter how it is configured)
NOTE: This formats in a non-consistent manner in the edit box, it needs to be a contiguous string formatted with spaces only between the end of the -<argument> and the next one.
3) Specify "Custom properties" (Websphere) as:
Name com.ibm.websphere.persistence.ApplicationsExcludedFromJpaProcessing Value CAOMWebViewer12.ear