INF: How to Start SQL Server

ID: Q40919

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 "PIPE" 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 "\\" prefix, the documentation should state that the "\\" 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