Hi,
I need to give access to our SQL Server 7.0 thru our MS proxy server 2.0 to remote users on the Web. I configured both Proxy and SQL servers according to MS Q216415 white paper. It doesn’t work. First, the SQL shows an error message in Event viewer regarding the port 1433. The message is:
error 17826 severity 18 state 1 ODS could not listen on connection 1433 Operating system error 10049.
Both TCP IP (pointing on the proxy external IP)and name pipes are enabled on the Server network library on the SQL. Same thing for client network library. They allow clients to connect to SQL using name pipes or TCP IP but the port 1433 is not listening.
What could prevent the port 1433 from listening?
I have to fix this ASAP so if someone has the solution, I’ll be very happy t ohear from him.
Thanks in advance.