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:
- SQLTESTR generates a "NET 803 ERROR: Network path not found" error.
- SQLTESTW fails with a DB-Library (DB-Lib) error when you use the connect option.
- ISQL generates a "NET818: Network name not found" error message.
CAUSE
This problem occurs if you are unable to access named pipes.
WORKAROUND
The following are two solutions to this problem:
- 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.
- 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