Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 IPX Broadcast on MSSQL 2000

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2002-06-24 : 01:27:27
Sri writes "Hi Everybody,

We have upgraded our Application from Windows NT Server to Win2k Advanced Server and from MSSQL 6.5 to MSSQL 2000. After this upgrade we have installed Nwlink IPX/SPX Protocol and GSNW on the Win2k Server and have configured MSSQL 2000 to listen on to IPX/SPX Protocol via Server Network Utility.

But when we try to connect to SQL Server via IPX Protocol either from the Server or Remote Client we are receiving the error "Unable to connect: SQL Server is unavailable or does not exist. Specified SQL Server not found.". Also IPX name is not broadcasted across network.

Also we receive the following error in the Event Log.

"A SAP announcement was sent over \Device\NwlnkIpx which is configured for multiple networks, but no internal network is configured. This may prevent machines on some networks from locating the advertised service. "

Please let us know if there is any additional configuration need to be done for MSSQL Server to Listen On via IPX/SPX. Also help us find solution to resolve this issue.


Kevin Snow
Posting Yak Master

149 Posts

Posted - 2002-06-25 : 09:57:26
Can you ping the server and get a response?

To enable IPX routing, you must install the IPX protocol and Routing Information Protocol (RIP) for IPX. The Service Advertising Protocol (SAP) agent installs automatically when you install RIP. IPX addresses, routes, and switches information packets to move single packets from one location to another in an inter-network (with the help of RIP and SAP).

Did you install RIP as well as IPX?

Edited by - kevin snow on 06/25/2002 10:18:52
Go to Top of Page

- Advertisement -