Microsoft KB Archive/40919

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2

-

LAN Manager SERVER service must be started before starting SQL Server. Also, if SHARE-LEVEL security is active on the server, IPC$ must be shared. The LAN Manager WORKSTATION service must be started on the workstation before attempting to connect to SQL Server.

If USER-LEVEL security is active on the server, LAN Manager accounts with permission to use the share name &quot;PIPE&quot; must be added for each workstation that is to use SQL Server. Workstations must execute a NET LOGON with a valid name and password before attempting to connect to SQL Server.

Also, since many of the LAN Manager services show server names with the &quot;\\&quot; prefix, the documentation should state that the &quot;\\&quot; prefix must not be included when specifying the server name to the SQL Server utilities (ISQL, SAF, BCP, CONSOLE, and so forth).

The following is a quick example of how to start ISQL:

ISQL -Usa -P -Sservername ('quit' to terminate) Additional query words: Platforms - LAN Manager

Keywords         : kbnetwork SSrvLAN SSrvServer Version          : 4.2 Platform         : OS/2 Issue type       : Last Reviewed: March 23, 1999