How to connect SQL Server 2014 through jdbc drive? JASPERSOFT STUDIO

Posted on February 13, 2019 at 2:01pm

Keep getting the error:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. 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.".

Jaspersoft® Studio
kshetty's picture
kshetty
53
Joined: Feb 6 2019 - 8:36am
Last seen: 4 years 3 months ago

3 Answers:

Posted on February 13, 2019 at 5:22pm

Check this article :

https://community.jaspersoft.com/wiki/error-connecting-mssql-datasource

vchiem's picture
vchiem
36671
Joined: May 1 2017 - 5:33pm
Last seen: 32 min 42 sec ago
Posted on February 14, 2019 at 7:04am

I did that, it didn't solve the issue. What would the connection url format be for a localdb server?

kshetty's picture
kshetty
53
Joined: Feb 6 2019 - 8:36am
Last seen: 4 years 3 months ago
Posted on February 14, 2019 at 3:57pm

Something like this:

jdbc:sqlserver://localhost:1433;databaseName=database

 

vchiem's picture
vchiem
36671
Joined: May 1 2017 - 5:33pm
Last seen: 32 min 42 sec ago
Feedback