rh1c Posted May 8, 2014 Share Posted May 8, 2014 Hi,I am new with Jaspersoft technology, I am trying to create a new datasource in EC2 with JDBC type, but gives me this error message which is something related to TCP/IP connection."The TCP/IP connection to the host [hostName] , port 1433 has failed. Error: "null. 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."I already tried some of the suggested configurations on SQL Server Configuration Manager for TCP/IP and Port settings, but still not working.Tried accessing the server with its port in command prompt using telnet and it is able to connect.Don't know what else I need to do on this.Really need to fix this up. I'm stuck on this.Any help is greatly appreciated!Thanks. Link to comment Share on other sites More sharing options...
mgeise Posted May 8, 2014 Share Posted May 8, 2014 It is likely that your DB is not accepting connections from the AWS instance. If your DB is also on AWS you will need to make sure that it is in the same security group, that the security group has the appropriate permissions on the port you are trying to connect to, etc. I hope this helps Link to comment Share on other sites More sharing options...
rh1c Posted May 9, 2014 Author Share Posted May 9, 2014 hi. thank you for your reply. my DB come from a remote server. It is using SQL Server 2005. Link to comment Share on other sites More sharing options...
rh1c Posted July 2, 2014 Author Share Posted July 2, 2014 Hi mgeise, thank you for your reply. But my DB is from a remote SQL Server not hosted by AWS. Do you think AWS Jaspersoft support this setup? Thanks, Ric Link to comment Share on other sites More sharing options...
mgeise Posted July 2, 2014 Share Posted July 2, 2014 If the server is reachable from AWS, there should not be a problem. If it is behind a firewall that your AWS account does not have the ability to get through via a VPC, then it won't be able to connect. You could try pinging the DB server from your AWS server or connecting from the command line to verify that it is reachable. It may also be that you are using a domain name for the server that AWS can not find and you may need to try using the IP address instead. Link to comment Share on other sites More sharing options...
rh1c Posted July 17, 2014 Author Share Posted July 17, 2014 hi, Thank you for the response. We are able to solve the connection issue by setting up VPN connection through our corporate network. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now