Microsoft KB Archive/42627

From BetaArchive Wiki
Knowledge Base

PRB: MS-DOS Workstation Fails to Connect with SQL and SQLTESTR

Article ID: 42627

Article Last Modified on 3/2/2005


  • Microsoft SQL Server 4.21a Standard Edition

This article was previously published under Q42627


After successfully running the installation procedures for both the server and the MS-DOS workstations, the MS-DOS workstations cannot use the SQL server. SQLTESTR, SQLTESTW, and ISQL each fail with the following error messages:

  1. SQLTESTR generates a "NET 803 ERROR: Network path not found" error.
  2. SQLTESTW fails with a DB-Library (DB-Lib) error when you use the connect option.
  3. ISQL generates a "NET818: Network name not found" error message.


This problem occurs if you are unable to access named pipes.


The following are two solutions to this problem:

  1. You may need to execute a NET SHARE IPC$ command. This is done automatically when using user-level security, but needs to be done manually in share-level security.
  2. You may not have enhanced MS-DOS LAN Manager named pipes available. These pipes are needed for the SQL Server. To check if these pipes are available, use the NET VIEW command. If NET VIEW returns "command not found," you have the basic LAN Manager installed, and if so, you need to install the enhanced MS-DOS LAN Manager.

Keywords: kbnetwork kbprb KB42627