Software

Ask something
Discussion Locked

SQL Server error 17826 severity 18

0 helpful
3 replies

by amiro2k

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by hypersoniq mcse

try this..(taken from SQL7 BOL...)
START/RUN/ type regedit32

STEP 1: navigate to
HKEY_LOCAL_MACHINE
\SOFTWARE
\MICROSOFT
\MSSQLSERVER
\MSSQLSERVER
\RPCNetlib

STEP 2 :create a new value named RPCprotocols and assign it a value type of REG_MULTI_SZ

STEP 3:For the value, enter ncacn_ip_tcp

This should direct the server to listen to port 1433... to specify another port, type ncacn_ip_tcp, portnumber

This discussion is closed to new replies.