Hi Pawan / Jose,

There is no issue in connecting the database with the credentials provided in Web.xml (when i try manually). Am not sure, why the smart reporting server is not able to connect with the database.

Is there any other configuration which need to be refreshed in the system?

Thanks,

Meyananth

Hi Ravi,

Please find the updates.

- Did you check the jdbc.log from the SmartReporting's log folder? This may have more details.

- Are you using bundled Tomcat or External? Is the tomcat being run using Service Account or Domain Account? Yes, we have Bundled Tomcat and run using Service Account.

- Is the SmartReporting database user using SQL or Windows Authentication? Using SQL Authentication

Error from JDBC.log

ARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host #######, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

2019-07-09 03:37:03  ERROR: Failed to create initial connection at DBConnectionPool startup. Giving up.

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host #######, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)

at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)

at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369)

at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:551)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1963)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)

at com.hof.pool.JDBCConnection.openConnection(JDBCConnection.java:179)

at com.hof.pool.DBConnection.authenticateAndOpenConnection(DBConnection.java:127)

at com.hof.pool.DBConnectionPool.A(DBConnectionPool.java:1211)

at com.hof.pool.DBConnectionPool.createJDBCPool(DBConnectionPool.java:567)

at com.hof.pool.DBConnectionManager.initialiseAppPool(DBConnectionManager.java:396)

at com.hof.servlet.InitConnectionPool.init(InitConnectionPool.java:222)

at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4913)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5223)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:596)

at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1805)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Also, am able to Ping the DB server name without any issues.

Thanks Ravi,

Issue got fixed.

In Smart Reporting Server, Host file having the wrong IP of DB server. We updated the correct IP address and the service restart established the connection with the DB.

Thanks,

Meyananth