How To: Uninstall An Existing Instance Of SQL Server 2005 (Setup)

Trang chủ » Gỡ Bỏ Sql Server 2005 » How To: Uninstall An Existing Instance Of SQL Server 2005 (Setup)

Có thể bạn quan tâm

How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)

SQL Server Setup

previous page next page
SQL Server Setup Help
How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
See Also  
: : : : : : :
Installing SQL Server 2005 Components > Installing SQL Server Components How-to Topics > Database Engine Installation How-to Topics >
(Declaration)

Use the following procedure to uninstall an instance of Microsoft SQL Server 2005.

Note:
You must perform the uninstall steps listed here in the exact order given.

Important:
To maintain or update a SQL Server instance, you must be a local administrator with permission to log on as a service.

Before you begin, consider the following important information before you uninstall SQL Server 2005:

On a computer running SQL Server 2005 along with previous SQL Server versions, Enterprise Manager and other programs that depend on SQL-DMO may be disabled. This may occur in the following situations:

  • Side-by-side installations of SQL Server 2005, SQL Server 2000, and/or SQL Server 7.0, where any of the versions is uninstalled.
  • Side-by-side installations of SQL Server 2000 with SQL Server 2005, where SQL Server 2000 is installed after SQL Server 2005.

This issue is due to removal of the registration for the SQL Server 2005 SQL-DMO COM library. To re-enable Enterprise Manager and other programs with SQL-DMO dependencies, register SQL-DMO by running ‘regsvr32.exe sqldmo.dll’ from a command prompt. For more information, see Troubleshooting an Installation of SQL Server 2005.

Note:
Before you remove SQL Server 2005 components from a computer that has the minimum required amount of physical memory you must ensure that the page file size is equal to two times the amount of physical memory. In some situations insufficient virtual memory may result in an incomplete removal of SQL Server 2005.

For information on command prompt syntax, see How to: Install SQL Server 2005 from the Command Prompt.

For information on removing a failover cluster, see How to: Remove a SQL Server 2005 Failover Clustered Instance (Setup).

To remove a SQL Server 2005 instance

  1. To begin the uninstall process, on the Microsoft Windows desktop click Start, click Control Panel, and then double-click Add or Remove Programs.

  2. Select the SQL Server 2005 component to uninstall, and then click Remove. This will start the SQL Server 2005 Installation Wizard.

  3. On the Component Selection - Uninstall page, select any server and/or shared components to remove.

    Click the Report button to view the list of SQL Server 2005 components and features installed on your computer. The report includes version, edition, update level, and language information for each installed component and feature.

    To continue, click Next.

  4. On the Confirmation - Uninstall page, review the list of components and features that will be removed. To continue, click Next.

  5. The Setup Progress page will display Setup status.

  6. On the Completing Setup page, click Finish to exit the Installation Wizard.

See Also

Tasks

How to: Read a SQL Server 2005 Setup Log File

Concepts

How to: View SQL Server 2005 Setup Log Files © 2006 Microsoft Corporation. All rights reserved. previous page start next page
  • Homepage

Table of contents

  • Installing SQL Server 2005
    • Editions and Components of SQL Server 2005
    • SQL Server 2005 Privacy Statement
    • Legal Notice
    • About the SQL Server 2005 End User License Agreement
  • Preparing to Install SQL Server 2005
    • Hardware and Software Requirements for Installing SQL Server 2005
    • Check Parameters for the System Configuration Checker
    • Security Considerations for a SQL Server Installation
    • Considerations for Running SQL Server 2005 on Windows Vista
    • Setting Up Windows Service Accounts
    • Features Supported by the Editions of SQL Server 2005
    • Configuring High Availability
      • Failover Clustering
        • Before Installing Failover Clustering
        • Installing a Failover Cluster
          • Failover Clustering Example
          • Upgrading to a SQL Server 2005 Failover Cluster
        • Maintaining a Failover Cluster
          • Optimizing Failover Cluster Performance
          • Using SQL Server Tools with Failover Clustering
          • Failover Cluster Troubleshooting
      • Configuring Availability How-to Topics
        • Failover Clustering How-to Topics
          • How to: Create a New SQL Server 2005 Failover Cluster (Setup)
          • How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)
          • How to: Change the IP Address of a SQL Server 2005 Failover Cluster
          • How to: Install Microsoft Distributed Transaction Coordinator
          • How to: Enable Windows Task Scheduler Service
          • How to: Enable Kerberos Authentication on a SQL Server Failover Cluster
          • How to: Upgrade to a SQL Server 2005 Failover Cluster (Setup)
          • How to: Rename a SQL Server 2005 Virtual Server
          • How to: Add Dependencies to a SQL Server 2005 Resource
          • How to: Remove a SQL Server 2005 Failover Clustered Instance (Setup)
          • How to: Manually Uninstall a SQL Server 2005 Failover Cluster
          • How to: Recover from Failover Cluster Failure in Scenario 1
          • How to: Recover from Failover Cluster Failure in Scenario 2
    • Collation Options and International Support
      • Collation Terminology
      • Collation Settings in Setup
      • Windows Collation Sorting Styles
      • Using Binary Collations
      • Using SQL Collations
        • Selecting a SQL Collation
      • Setting Client Code Pages
    • Working with Multiple Versions of SQL Server
    • SQL Server 2005 Preparation How-to Topics
      • How to: Change Operating System Settings to Support Localized Versions
      • How to: Disable NetBIOS over TCP/IP
      • How to: Disable Server Message Block
      • How to: Verify Permissions for SQL Server Services
  • Upgrading to SQL Server 2005
    • Version and Edition Upgrades
    • Using Upgrade Advisor to Prepare for Upgrades
    • Upgrading SQL Server Components
      • Upgrading the Database Engine
      • Upgrading or Migrating Analysis Services
        • Migrating Existing Analysis Services Databases
        • Migration Considerations (SSAS)
      • Upgrading Reporting Services
        • Upgrading a Default Installation of Reporting Services
        • Upgrading Reports
        • Updating Role-Based Security for Report Builder Access
        • Upgrading a Report Server Database
        • Upgrading Editions of Reporting Services
        • Upgrading a Report Server Web Farm
        • Migrating Reporting Services
        • How to: Upgrade a SQL Server Express Report Server to Other SQL Server Editions
      • Upgrading or Migrating Data Transformation Services
        • Migrating Data Transformation Services Packages
          • Using the Package Migration Wizard
          • Known Package Migration Issues
          • Migrating Tasks
          • Migrating Precedence Constraints
          • Migrating Variables
          • Migrating Connections
          • Migrating Passwords
          • Migrating Scripts
        • Upgrading dtsrun Command Lines
      • Migrating Notification Services Instances
        • Migrating Notification Services 2.0 Instances to SQL Server 2005
        • Migrating Notification Services Instances to a Higher Edition of SQL Server 2005
      • Upgrading Replicated Databases
      • Upgrading SQL Server Components How-to Topics
        • Upgrading the Database Engine How-to Topics
          • How to: Upgrade to SQL Server 2005 (Setup)
          • How to: Upgrade to a SQL Server 2005 Failover Cluster (Setup)
        • Upgrading or Migrating Analysis Services How-to Topics
          • How to: Upgrade an Instance of Analysis Services
          • How to: Migrate Analysis Services Databases
        • Upgrading or Migrating Data Transformation Services How-to Topics
          • How to: Upgrade from Data Transformation Services to Integration Services
          • How to: Migrate Data Transformation Services Packages to Integration Services
        • Migrating Notification Services How-to Topics
          • How to: Migrate Notification Services 2.0 Instances to SQL Server 2005 (SQL Server Management Studio)
          • How to: Migrate Notification Services 2.0 Instances to SQL Server 2005 (Command Prompt)
          • How to: Migrate Notification Services Instances to a Higher Edition (SQL Server Management Studio)
          • How to: Migrate Notification Services Instances to a Higher Edition (Command Prompt)
          • How to: View Notification Services Version Information
    • Backward Compatibility
      • SQL Server 2005 Database Engine Backward Compatibility
        • Deprecated Database Engine Features in SQL Server 2005
        • Discontinued Database Engine Functionality in SQL Server 2005
        • Breaking Changes to Database Engine Features in SQL Server 2005
        • Behavior Changes to Database Engine Features in SQL Server 2005
        • SQL Server 2005 and SQL Server 2000
          • Distributed Management Objects
          • English Query
          • Meta Data Services
      • SQL Server 2005 Analysis Services Backward Compatibility
        • Deprecated Analysis Services Functionality in SQL Server 2005
        • Discontinued Analysis Services Functionality in SQL Server 2005
        • Known Upgrade Issues for SQL Server 2005 Analysis Services
        • Behavior Changes to Analysis Services Features in SQL Server 2005
      • Reporting Services Backward Compatibility
        • Deprecated Features in SQL Server 2005 Reporting Services
        • Discontinued Functionality in SQL Server 2005 Reporting Services
        • Breaking Changes in SQL Server 2005 Reporting Services
        • Behavior Changes in SQL Server 2005 Reporting Services
      • SQL Server 2005 Integration Services Backward Compatibility
        • Breaking Changes to Integration Services Features in SQL Server 2005
        • Deprecated Features in SQL Server 2005 Integration Services
        • Setting DTS Application Properties
      • Notification Services Backward Compatibility
      • Replication Backward Compatibility
        • Deprecated Features in SQL Server 2005 Replication
        • Discontinued Functionality in SQL Server 2005 Replication
        • Breaking Changes in SQL Server 2005 Replication
        • Behavior Changes in SQL Server 2005 Replication
        • Using Multiple Versions of SQL Server in a Replication Topology
      • Full-Text Search Backward Compatibility
        • Breaking Changes to Full-Text Search in SQL Server 2005
        • Behavior Changes to Full-Text Search in SQL Server 2005
  • Installing SQL Server 2005 Components
    • Installing the SQL Server Database Engine
      • Components of the SQL Server Database Engine
      • Remote Setup Information for SQL Server 2005
        • Running Setup from the Command Prompt
        • Specifying Setup Properties with an .ini File
      • Troubleshooting an Installation of the SQL Server Database Engine
    • Installing SQL Server Analysis Services
      • Installing SQL Server Analysis Services by Using Setup
      • Installing SQL Server Analysis Services from the Command Prompt
    • Installing SQL Server Reporting Services
      • Selecting Reporting Services Components to Install
      • Default Configuration for a Report Server Installation
      • Installing Reporting Services Using Setup
      • Installing Reporting Services from the Command Prompt
      • Installing the Reporting Services Add-in
      • Installing Reporting Services on 64-bit Computers
      • Installing Multiple Instances of Reporting Services
    • Installing SQL Server Integration Services
      • Installing SQL Server Integration Services by Using Setup
      • Installing SQL Server Integration Services from the Command Prompt
    • Installing SQL Server Notification Services
      • Installing Notification Services Using Setup
      • Installing Notification Services from the Command Prompt
    • Installing SQL Server Replication
    • Installing AdventureWorks Sample Databases and Samples
      • Running Setup to Install AdventureWorks Sample Databases and Samples
      • Reinstalling Sample Databases from Script
      • Downloading Northwind and pubs Sample Databases
    • Installing SQL Server Components How-to Topics
      • Database Engine Installation How-to Topics
        • How to: Install SQL Server 2005 (Setup)
        • How to: Work Around COM+ System Configuration Check Failure in SQL Server Setup
        • How to: Increment the Counter Registry Key for Setup in SQL Server 2005
        • How to: Install SQL Server 2005 from the Command Prompt
        • How to: Install Microsoft Internet Information Services
        • How to: Verify a Successful Installation of SQL Server 2005 Services
        • How to: Change Components in an Existing Instance of SQL Server 2005 (Setup)
        • How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005
        • How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
        • How to: Manually Uninstall an Existing Instance of SQL Server 2005
        • How to: Uninstall an Existing Instance of SQL Server 2000 or 7.0
        • How to: View SQL Server 2005 Setup Log Files
        • How to: Read a SQL Server 2005 Setup Log File
        • How to: Rebuild the Master Database for SQL Server 2005
        • How to: Rebuild the Registry for SQL Server 2005
        • How to: Access Books Online for SQL Server 2005
        • How to: Access Books Online for SQL Server 2000
        • How to: Access Books Online for SQL Server 7.0
      • Analysis Services Installation How-to Topics
        • How to: Install Analysis Services by Using Setup
        • How to: Install Analysis Services from the Command Prompt
        • How to: Install Analysis Services on a Failover Cluster
        • How to: Install Multiple Instances of Analysis Services
        • How to: Install Analysis Services Side-by-Side with an Earlier Version
        • How to: Rename an Instance of Analysis Services
        • How to: Add or Remove Features for an Instance of Analysis Services
        • How to: Uninstall an Instance of Analysis Services
      • Reporting Services Installation How-to Topics
        • How to: Install Reporting Services on a Single Computer
        • How to: Install a Local Report Server and Remote Report Server Database
        • How to: Install Reporting Services Side-by-Side with an Earlier Version
        • How to: Install the Windows SharePoint Services Object Model on a Report Server Computer
        • How to: Uninstall the Reporting Services Add-in
        • How to: Uninstall an Instance of Reporting Services
        • How to: Verify a Reporting Services Installation
        • How to: Troubleshoot a Reporting Services Installation Problem
        • How to: Troubleshoot Side-by-Side Installations of SQL Server 2000 and SQL Server 2005 Reporting Services
        • How to: Configure IIS to Run 32-bit Reporting Services in WOW64 Mode
      • Integration Services Installation How-to Topics
        • How to: Install Integration Services by Using Setup
        • How to: Install Integration Services from the Command Prompt
        • How to: Add Integration Services to an Existing Instance of SQL Server 2005
        • How to: Configure Integration Services on a Cluster
        • How to: Ensure Support for Data Transformation Services Packages
      • Notification Services Installation How-to Topics
        • How to: Install Notification Services and the Database Engine
        • How to: Install the Notification Services Engine Components
        • How to: Install the Notification Services Client Components
        • How to: Uninstall Notification Services
        • How to: Register the Core Notification Services Assembly for COM Interop
  • Installing SQL Server Express
    • Hardware and Software Requirements (SQL Server Express)
    • Before You Install SQL Server Express
    • Using Command Prompt Options to Install SQL Server Express
    • Installing Sample Databases for Express Editions
    • Upgrading MSDE to SQL Server Express
    • How to: Enable Network Access During Installation (SQL Server Express)
    • How to: Install SQL Server Express
    • How to: Uninstall SQL Server Express
  • Configuring a SQL Server Installation
    • SQL Server Surface Area Configuration
      • Surface Area Configuration for Features
        • Surface Area Configuration for Features (Ad Hoc Remote Queries) - Database Engine
        • Surface Area Configuration for Features (CLR Integration) - Database Engine
        • Surface Area Configuration for Features (DAC) - Database Engine
        • Surface Area Configuration for Features (Database Mail) - Database Engine
        • Surface Area Configuration for Features (Native XML Web Services) - Database Engine
        • Surface Area Configuration for Features (OLE Automation) - Database Engine
        • Surface Area Configuration for Features (Service Broker) - Database Engine
        • Surface Area Configuration for Features (SQL Mail) - Database Engine
        • Surface Area Configuration for Features (Web Assistant) - Database Engine
        • Surface Area Configuration for Features (xp_cmdshell) - Database Engine
        • Surface Area Configuration for Features (Ad Hoc Data Mining Queries) - Analysis Services
        • Surface Area Configuration for Features (Anonymous Connections) - Analysis Services
        • Surface Area Configuration for Features (Linked Objects) - Analysis Services
        • Surface Area Configuration for Features (User-Defined Functions) - Analysis Services
        • Surface Area Configuration for Features (Scheduled Events and Report Delivery) - Reporting Services
        • Surface Area Configuration for Features (Web Service and HTTP Access) - Reporting Services
        • Surface Area Configuration for Features (Windows Integrated Security) - Reporting Services
      • Surface Area Configuration for Services and Connections
        • Surface Area Configuration for Services and Connections (Service) - Database Engine
        • Surface Area Configuration for Services and Connections (Remote Connections) - Database Engine
        • Surface Area Configuration for Services and Connections (Service) - Analysis Services
        • Surface Area Configuration for Services and Connections (Remote Connections) - Analysis Services
        • Surface Area Configuration for Services and Connections (Service) - Reporting Services
        • Surface Area Configuration for Services and Connections (Service) - SQL Server Agent
        • Surface Area Configuration for Services and Connections (Service) - Full-Text Search
        • Surface Area Configuration for Services and Connections (Service) - Notification Services
        • Surface Area Configuration for Services and Connections (Service) - Integration Services
        • Surface Area Configuration for Services and Connections (Service) - SQL Server Browser
      • sac Utility
    • Reporting Services Configuration
      • Configuring a Report Server for Internet Access
      • Configuring a Report Server Scale-Out Deployment
      • Deployment Modes for Reporting Services
      • Configuring Reporting Services for SharePoint 3.0 Integration
        • Reporting Services and SharePoint Technology Integration
          • Features Supported by Reporting Services in SharePoint Integration Mode
          • Viewing and Managing Report Server Items from a SharePoint Site
          • Security Overview for Reporting Services in SharePoint Integration Mode
          • Storing and Synchronizing Report Server Content With SharePoint Databases
          • Comparing Levels of Integration Across Versions of Reporting Services and SharePoint Technologies
        • Requirements for Running Reporting Services in SharePoint Integrated Mode
      • Configuring Report Server Virtual Directories
      • Configuring Service Accounts and Passwords in Reporting Services
      • Creating a Report Server Database
      • Configuring a Report Server Database Connection
      • Configuring an Account for Unattended Report Processing
      • Configuring a Report Server for E-Mail Delivery
      • Administering a Report Server Database
      • Administering the Report Server Web Service and Windows Service
      • Starting and Stopping the Report Server Windows Service
      • Managing Encryption Keys
        • Initializing a Report Server
        • Backing Up and Restoring Encryption Keys
        • Deleting and Re-creating Encryption Keys
        • Adding and Removing Encryption Keys for Scale-Out Deployment
      • Reporting Services Configuration How-to Topics
        • How to: Start Reporting Services Configuration
        • How to: Configure Service Accounts (Reporting Services Configuration)
        • How to: Configure Reporting Services to Use a Non-Default Web Site (Reporting Services Configuration)
        • How to: Create a Report Server Database (Reporting Services Configuration)
        • How to: Create a Report Server Database for SharePoint Integrated Mode (Reporting Services Configuration)
        • How to: Set Report Server Integration in SharePoint Central Administration
        • How to: Switch Server Modes (Reporting Services Configuration)
        • How to: Configure a Report Server Scale-Out Deployment (Reporting Services Configuration)
        • How to: Configure a Report Server Database on a Database Engine Upgraded from SQL Server 7.0 (Reporting Services Configuration)
        • How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration)
        • How to: Enable Remote Errors (Reporting Services Configuration)
      • Reporting Services Configuration F1 Help
        • Report Server Status (Reporting Services Configuration)
        • Report Server Virtual Directory (Reporting Services Configuration)
        • Report Manager Virtual Directory (Reporting Services Configuration)
        • Windows Service Identity (Reporting Services Configuration)
        • Web Service Identity - Windows Server 2003 (Reporting Services Configuration)
        • Web Service Identity (Reporting Services Configuration)
        • Database Setup (Reporting Services Configuration)
        • SharePoint Integration (Reporting Services Configuration)
        • Encryption Keys (Reporting Services Configuration)
        • Initialization (Reporting Services Configuration)
        • E-mail Settings (Reporting Services Configuration)
        • Execution Account (Reporting Services Configuration)
    • Network Protocols and Network Libraries
    • File Locations for Default and Named Instances of SQL Server 2005
    • Changing Passwords and User Accounts
    • System and Sample Databases
    • Product Specifications for SQL Server 2005
      • Maximum Capacity Specifications for SQL Server 2005
      • Maximum Number of Processors Supported by the Editions of SQL Server 2005
      • Memory Supported by the Editions of SQL Server 2005
  • Setup User Interface Reference
    • Installing Prerequisites
    • System Configuration Check (SCC)
    • Registration Information
    • Components to Install
    • Feature Selection
    • Instance Name
    • Installed Instances
    • Existing Components
    • Installation Options
    • Service Account
    • Authentication Mode
    • Collation Settings
    • Report Server Installation Options
    • Report Server Installation Details
    • Error and Usage Report Settings
    • Ready to Install
    • Upgrade Logon Information
    • Upgrade Blocked
    • Virtual Server Name
    • Virtual Server Configuration
    • Cluster Group Selection
    • Service Accounts (Clusters)
    • Domain Groups for Clustered Services
    • Cluster Node Configuration
    • Remote Account Information
    • Change or Remove Instance
    • Cluster Maintenance
    • Setup Progress
    • Reserved Keywords (Setup)
    • Component Selection - Maintenance
    • Sample Databases Setup
    • Component Selection - Uninstall
    • Confirmation - Uninstall
    • Instance Type - Uninstall
    • Orphan Component Selection
    • Setup User Interface Reference (SQL Server Express)
      • System Configuration Check (SQL Server Express)
      • Registration Information (SQL Server Express)
      • Feature Selection (SQL Server Express)
      • Instance Name (SQL Server Express)
      • Existing Components (SQL Server Express)
      • Installation Options (SQL Server Express)
      • Service Account (SQL Server Express)
      • Authentication Mode (SQL Server Express)
      • Collation Settings (SQL Server Express)
      • Configuration Options (SQL Server Express)
      • Error and Usage Report Settings (SQL Server Express)
      • Ready to Install (SQL Server Express)
      • Maintenance Feature Selection

Submit feedback about this site to:

  • [email protected]

Từ khóa » Gỡ Bỏ Sql Server 2005