Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005

How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005

Bug #: 414150 (SQLBUDT)

↑ Back to the top

INTRODUCTION

Microsoft SQL Server 2005 tools can be used to manage, to administer, and to configure SQL Server 2005. They also offer a rich set of other functionalities. Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high-performance data integration solutions that include extraction, transformation, and load (ETL) packages for data warehousing. SSIS is also required to configure and to execute SQL Server maintenance plans successfully. This article describes how to add the tools or the SSIS components to an existing instance of SQL Server 2005.

Note Microsoft SQL Server 2005 feature maintenance is supported only through the Add or Remove Programs item in Control Panel.

↑ Back to the top

More Information

To add the SQL Server 2005 tools or SSIS to an existing instance of SQL Server 2005, follow these steps:
  1. In Control Panel, open Add or Remove Programs.
  2. Under Currently installed programs, select Microsoft SQL Server 2005, and then click Change.
  3. On the Component Selection page, click To install a new component, click here.
  4. Type the location of the Setup.exe file on the SQL Server 2005 installation media, and then click OK.

    Note You must include the Setup.exe file name.
  5. On the End User License Agreement page, read the license agreement, and then click to select the check box to accept the license terms and conditions. When you accept the license agreement, the Next button is available. To continue, click Next. To end Setup, click Cancel.
  6. On the Installing Prerequisites page, the Setup program installs software that is required for SQL Server 2005. For more information about component requirements, click the Help button. Click Next.
  7. On the Welcome page, click Next.
  8. On the System Configuration Check (SCC) page, the destination computer is scanned for conditions that may block the Setup program. For more information about configuration check items, click Help. After the SCC scan is completed, click Next.
  9. On the Registration Information page, click Next. A product key is not required to add components to an existing instance of SQL Server 2005.
  10. On the Components to Install page, click to select Workstation components, Books Online and Development Tools to install the tools. Click to select Integration Services to install SSIS. Click Next.
  11. On the Error and Usage Reporting page, optionally click to clear the check box to disable error reporting. For more information about error reporting functionality, click Help. Click Next.
  12. On the Ready to Install page, click Install.
  13. On the Setup Progress page, you can monitor installation progress as the setup process occurs. To view the log file for a component during installation, click the product or status name on the Installation Progress page. After the Setup program finishes configuring SQL Server components, click Next.
  14. On the Completing the Microsoft SQL Server Setup page, click Finish.
  15. If you are prompted to restart the computer, restart the computer. You must read the message from the Setup program when installation has finished.

↑ Back to the top

Keywords: kbsql2005ssis, kbsql2005tool, kbexpertiseinter, kbexpertiseadvanced, kbtshoot, kbinfo, kb

↑ Back to the top

Article Info
Article ID : 913967
Revision : 6
Created on : 4/20/2018
Published on : 4/20/2018
Exists online : False
Views : 94