Testing an Installation

When a server installation or upgrade is complete, you can test the installation by connecting to it locally by running the isql utility from the server computer.

    To test the installation
  1. Reboot the server computer, and then start SQL Server by typing the following from an operating-system prompt:

    net start mssqlserver

  2. Connect to SQL Server by typing:

    isql /Usa /P

    If isql connects, you'll see the following isql prompt:

    1>

    If isql cannot connect, you'll get a DB-Library error. (For help in identifying and correcting the problem, see Chapter 7, Installation Troubleshooting.)

  3. Enter a simple query by typing:

    select @@servername
    go

    The isql 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 version 6.0 server by typing:

    select @@version
    go

    The isql utility returns the version information.

  5. Quit the isql utility by typing:

    exit