Export (0) Print
Expand All

Testing an Installation of SQL Server 2000

SQL Server 2000

Before a server installation is complete, SQL Server Setup starts and connects to the server. When the installation is complete, you can test the installation yourself and connect to it locally by running the osql utility from the server.

To test an installation of SQL Server 2000 (Command Prompt)

  1. Start Microsoft® SQL Server™ by entering from a command prompt:
    net start mssqlserver 
  2. Connect to SQL Server by entering:
    osql /Usa /P<administrator password> 

    If osql connects, this osql prompt appears:

    1> 

    If osql cannot connect, an ODBC error is returned.

  3. Enter a simple query, for example
    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 2000 server by entering:
    SELECT @@VERSION
    GO 

    The osql utility returns the version information.

  5. Quit the osql utility by entering:
    exit 
    
Show:
© 2014 Microsoft