Archive for the ‘SQL 2000 Server’ Category

Installing SQL Server 2000 Client Tools

Tuesday, January 5th, 2010

Installation

To install Microsoft SQL Server 2000 Client Tools, do the following steps:

  1. Insert the Microsoft SQL Server 2000 Enterprise Edition CD and click SQL Server 2000 Components.
  2. Click Install Database Server.The Microsoft SQL Server 2000 Enterprise Edition setup begins. The InstallShield guides you through the installation. Follow the instructions in the windows. Click Next.
  3. From the Welcome window, read the information and click Next.
  4. From the Computer Name window, click Local Computer and click Next.
  5. From the Installation Selection window, click Create a new instance of SQL Server, or install Client Tools. Click Next.
  6. From the User Information window, type your name and company. Click Next.
  7. From the Software License Agreement window, read the license information. You must accept the license agreement to continue the installation. Click Yes.
  8. From the Installation Definition window, click Client Tools Only. Click Next.
  9. From the Setup window, type your CD key information and click OK.
  10. Your product ID is displayed in the second setup window. Follow the instructions and click OK to continue.
  11. From the Setup Type window, click Next to accept the default values.
  12. From the Select Components window, click Next to accept the default values.
  13. When the Start Copying Files window opens, click Next to continue with the installation.If you want to change any parameters, click Back. When you click Back, selections reset back to their default values. If you click Back at any time during the installation, make sure you reselect the values you wanted before clicking Next.
  14. Click Finish on the Setup Complete window.

Disabling Selected SQL Server 2000 Query Analyzer Options

Certain SQL Server Query Analyzer options must be manually disabled in SQL Server 2000 for every Windows(R) account that is used to run the Query Analyzer tool.

To disable these options, do the following steps:

  1. Start the SQL Server 2000 Query Analyzer. Click Start -> Programs -> Microsoft SQL Server -> Query Analyzer.
  2. In the Connect to SQL Server window, enter the database server name in the SQL Server field. Leave the Start SQL Server if it is stopped check box clear. Type your password. Click OK.
  3. From the Query Analyzer window, click Tools -> Options.
  4. Click the Connection Properties tab.
  5. Make sure the only check box selected is Set arithabort. (Clear the Set concat_null_yields_null check box and the Set ansi_defaults check box. Make sure this clears all seven check boxes underneath it).
  6. Click Apply, then OK to close the window.
  7. Close the Enterprise Manager and SQL Server Query Analyzer applications.