Testing an Installation of 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