Microsoft KB Archive/42627

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

Article ID: 42627

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q42627



SYMPTOMS
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 &quot;NET 803 ERROR: Network path not found&quot; error.
 * 2) SQLTESTW fails with a DB-Library (DB-Lib) error when you use the connect option.
 * 3) ISQL generates a &quot;NET818: Network name not found&quot; error message.



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



WORKAROUND
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 &quot;command not found,&quot; you have the basic LAN Manager installed, and if so, you need to install the enhanced MS-DOS LAN Manager.

Keywords: kbnetwork kbprb KB42627

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.