AnsweredAssumed Answered

Jaspersoft reports not working after Sql Server IPs are changed.

Question asked by AbdulSalam1313830 on May 19, 2016
Latest reply on May 23, 2016 by Suman Pramanik

Recently our server are moved to new premises and so server IPs are changed now. Now we are getting error in running jaspersoft OOB reports (Financial mgmt.,Investment mgmt. etc) .error says: The TCP/IP connection to the host 5.40.240.160, port 1433 has failed. Error: "connect timed out. 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.". com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 5.40.240.160, port 1433 has failed. Error: "connect timed out. Verify the connection in this not sure why it is still pointing to old  5.40.240.160 as our new IP is different now something like 94.97.245.167. I am able to create new connection for my custom report with the new IP. Can someone please help me in resolving this if the sqlserver hostname is stored in any of jaspersoft properties file?

Outcomes