Issue Description:You are trying to create a MSSQL SQLEXPRESS datasource in JasperReports Server. You have checked the URL and driver fields and they are correct. You have tried to turn off the Firewall or open the port or even all ports, but you are still getting the following error when you hit 'Test Connection'. | [toc] |
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.".
Resolution:
- Open SQL Server Configuration Manager, under SQL Server Network Configuration
- Find something like -> Protocols for SQL SQLEXPRESS
- Select it and Enable TCP/IP
- Clck on TCP/IP to get the tab IP Addresses
- Set the TCP Port in section IPAll to 1433 (this is the default port number, you can set it to the port that you are using).
Ref. Case #00031745
Recommended Comments
There are no comments to display.