INF: How to Start SQL Server

Last reviewed: April 25, 1997
Article ID: Q40919

The information in this article applies to:

  - Microsoft SQL Server version 4.2 for OS/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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.