• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 30737
  • Open Date : 2019/09/09 15:51
  • Print
NEW

[DataSpider Servista] An error occurred when connecting to SQL Server.

The following error occurs when connecting to SQL Server:
 
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <IP address>, 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.”
 
I checked the TCP/IP settings on the SQLServer server, a firewall, etc., but I do not quite understand the cause. Please explain what are the cause and a way to resolve this problem.
 
 
Category : 

Answer

Probable Cause
 
The error you are experiencing is occurring in the JDBC driver of SQL Server. For details about the cause, you must check the specification of the JDBC driver.
 
However, there was a similar case in the past and it was resolved by changing the settings on the SQL Server side.
 
Past Cases
 
  • A user made errors in the items such as Communication settings, database name, user name
 
In the past case, the settings required communicating with SQL Server such as enabling/disabling TCP / IP, database name, user name, and password were incorrect and it was resolved by confirming these settings
 
Please refer to the following page for the settings required communicating with SQL Server.
 
  • Troubleshooting for a connection (*Microsoft page)
 
TCP ports are changed dynamically
 
In the past case, this error occurred in an environment where it was configured to use TCP ports dynamically. However, the error was resolved just by fixing the TCP port.
 
The following page describes how to fix the TCP port.
 
・ How to configure a server to wait for a reception on a specific TCP port (SQL Server Configuration Manager) (*Microsoft page)