O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Current Limitations

As any other new feature, SQL Server's multi-instances has a lot of great and useful characteristics, but also has some limitations.

  • First of all, not all network libraries work with instances. Specifically, only named pipes, TCP/IP, and NWLink can be configured in a server with multiple instance installations. The remaining ones that don't work with SQL Server instances are Multiprotocol, AppleTalk, and Banyan VINES, which Microsoft didn't enhance in SQL Server 2000. This is the reason they cannot be used to communicate with named instances.

  • In a server with multiple instances, there's only one version of the client tools. For example, if there's a default instance running SQL Server 7.0, and then a SQL Server 2000 named instance ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required