How to test an installation of SQL Server 7.0 (Command Prompt)

To test the installation

1. Start Microsoft® SQL Server™ by entering from a command prompt:

   net start mssqlserver

     

2. Connect to SQL Server by entering:

   osql /Usa /P

     

   If osql connects, this osql prompt appears:

   1>

     

   If osql cannot connect, an ODBC error is returned.

3. Enter a simple query:

   SELECT @@SERVERNAME
GO

     

   The osql utility returns the server name, as shown in this example:

   1> SELECT @@SERVERNAME

   2> GO

   -------------------------------

   WOLFHOUND

     

   (1 row affected)

   1>

     

4. Verify that you have checked a SQL Server version 7.0 server by entering:

   SELECT @@VERSION
GO

     

   The osql utility returns the version information.

5. Quit the osql utility by entering:

   exit