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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 IPX Broadcast on MSSQL 2000
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 06/24/2002 :  01:27:27  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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.

Regards
Sri"

Kevin Snow
Posting Yak Master

149 Posts

Posted - 06/25/2002 :  09:57:26  Show Profile  Reply with Quote
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?

http://www.winnetmag.com/Articles/Index.cfm?ArticleID=546

Edited by - kevin snow on 06/25/2002 10:18:52
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000