OK, so you’re asked to support or manage an application that uses MSSQL Server. For example, many web hosting companies offer MSSQL Server as their preferred RDBMS.
If you need to remotely access and/or manage a Microsoft SQL Server and don’t have access to a machine running the management tools (called Enterprise Manager, found on the SQL Server install CDROM), you might wonder how you can access your database. However, there is hope! You can download the SQL Server evaluation version and install the client tools only. I have reproduced an excerpt from the Microsoft help file on the evaluation install program below.
The trial version of Microsoft SQL Server Enterprise Manager can be downloaded from Microsoft’s web site.
This content has been taken from the SQL Server Setup Help document.
How to install client tools only (Setup)
You can install client tools only using any SQL Server compact disc, on any supported operating system.
To install client tools only for SQL Server 2000
1. Insert the Microsoft® SQL Server™ 2000 compact disc in your CD-ROM drive. If the compact disc does not autorun, double-click Autorun.exe in the root directory of the compact disc.
2. Select SQL Server 2000 Components , select Install Database Server , and then click Next at the Welcome screen of the SQL Server Installation Wizard.
3. In Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the edit box. Click Next .
4. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools , and then click Next .
5. Follow the directions on the User Information , Software License Agreement , and related screens.
6. In the Installation Definition dialog box, click Client tools only , and then click Next .
7. In the Select Components dialog box, accept the defaults or select the components you want, and then click Next .
8. You can select an item in the Components list, such as Management Tools , and then select items from the related Sub-Components list, such as Enterprise Manager . Click to select items you want to install; clear the check box of the items you do not want to install.
9. For information about each component, select the item, and view the Description box.
10. In the Start Copying Files dialog box, click Next to complete the installation of the client tools.
©1988-2000 Microsoft Corporation. All Rights Reserved.