How to Install Microsoft SQL Query Analyzer

by Lysis

SQL Server 2000 comes with a tool called Query Analyzer. The application is used to run query commands against the SQL Server. Newer versions of SQL Server use the Microsoft SQL Management console. The Query Analyzer tool is a separate product from the SQL Server software. You can use your SQL Server installation CD to install the Query Analyzer application separately on development machines, so programmers can test queries and run reports against the server's data tables.


Insert the SQL Server installation CD or DVD into the drive. The autoplay function will start the installation application automatically.


Select "Create a new instance of SQL Server, or install Client Tools" from the installation start screen and click "Next." Enter the company name when prompted. If SQL Server is already installed, this value will default to what was entered when you installed the server application.


Check the box labeled "I agree" at the user software agreement. If you don't agree, the installation application stops. Click "Yes" at the confirmation screen.


Select "Client Tools Only" from the installation options. Click "Next." At the serial number window, enter the installation key located on the CD or DVD packaging. The serial number is a bright yellow strip located on the CD or DVD cover.


Click "Next" three times through the default screens. Click "Finish" at the summary screen. The SQL Server Query Analyzer tool is installed. It may take several minutes for the tools to finish installation.

Items you will need

About the Author

Lysis is the pen name for a former computer programmer and network administrator who now studies biochemistry and biology while ghostwriting for clients. She currently studies health, medicine and autoimmune disorders. Lysis is currently pursuing a Ph.D. in genetic engineering.

Photo Credits

  • photo_camera Visage/Stockbyte/Getty Images