Microsoft SQL Server

This appendix provides some additional information about the SQL Server installation in combination with LN.

To test the SQL Server installation

When the SQL Server installation is complete, to test the installation, connect to the server locally with the OSQL utility from the server. Take the following steps.

  1. Log on as a user with administrator’s rights.
  2. Click Start -> Programs-> Command Prompt.
  3. Enter the following command to connect to the SQL Server:
    • C:\> osql /Usa /P
  4. Verify that the command displays the following prompt:
    • 1>
    • This confirms that osqlcan connect to the database server.
Note

If osql cannot connect, a DB-Library error appears. For more information, refer to the Microsoft SQL Server for Windows 2000 Configuration Guide or to the Microsoft SQL Server Troubleshooting Guide.