SQL Gateway – [ERROR] Could not bind server socket.

  • 10 October 2023
  • 0 replies
  • 149 views

Userlevel 2
Badge

Error ‘Could not bind server socket: Only one usage of each socket address (protocol/network address/port) is normally permitted”. 

This error message usually indicates that we are using a port that is already in use. 

 

We can overcome this issue by some simple steps. 

Firstly, we must check for the free ports using a simple command in CMD: netstat -ano 

 

 

 

We see that port 1434 is occupied in another process but I have port 1435 free, so we are good to go with this port. 

Now we can open CData SQL Gateway, select your DNS (Data Source Name) that you are trying to start, and press edit button.  

 

 

 

 

2) In this window we can easily change port by just by typing in the new number. 

 

 

 

  1. The last step would be to just Save Changes, and you will be good to go with Starting this service. 

 

 

 

 

 

 

As we see, we successfully overcome the error. 

 

Please reach out to support@cdata.com if this does not resolve the problem for you. 


This topic has been closed for comments