Skip to content

sql-server-components.md

Latest commit

 

History

History
65 lines (48 loc) · 3.86 KB

sql-server-components.md

File metadata and controls

65 lines (48 loc) · 3.86 KB
title SQL Server Components | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
helpviewer_keywords
SQL Server Upgrade Advisor, components
listing components to analyze
Upgrade Advisor [SQL Server], components
component analysis [Upgrade Advisor]
finding components to analyze
locating components to analyze
detecting components to analyze
server names [Upgrade Advisor]
analyzing system [Upgrade Advisor], component list
identifying components to analyze
ms.assetid 539b9525-ce3f-4950-9146-5527a5a297ee
author mashamsft
ms.author mathoma
manager craigg

SQL Server Components

You can run the Upgrade Advisor Analysis Wizard against a local or remote computer that has [!INCLUDEssVersion2005], [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], or [!INCLUDEssSQL11] installed. The first step in the pre-upgrade analysis is to identify the computer and components for analysis.

Options

Computer name
Specifies the name of the computer to analyze. Upgrade Advisor populates the Server name box with the local computer name. You can also use "." and "localhost" to connect to the local computer.

To analyze a different computer, use the following guidelines:

  • To scan nonclustered instances, enter the computer name.

  • To scan clustered instances, enter the name of the [!INCLUDEssNoVersion] failover cluster instance.

  • To scan nonclustered components that are installed on a node of a cluster, enter the computer name of the failover cluster node.

    [!IMPORTANT]
    Do not include the [!INCLUDEssNoVersion] instance name.

Instead of specifying the computer name, you can specify the IP address.

If scanning [!INCLUDEssRSnoversion], you must specify the name of the local computer. Upgrade Advisor scans local report servers only.

Detect
The Detect button accesses the specified computer and detects components to analyze:

  • If you are analyzing a [!INCLUDEssNoVersion] instance on a remote computer, you must enable the remote registry services on the remote computer.

  • [!INCLUDEssNoVersion] is detected if an instance of [!INCLUDEssVersion2005], [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], or [!INCLUDEssSQL11] is found in the computer's registry.

  • [!INCLUDEssASnoversion] is detected if an instance of [!INCLUDEssASnoversion] is found in the computer's registry.

  • [!INCLUDEssRSnoversion] is detected if [!INCLUDEssRSnoversion] is found in the computer's registry. However, Upgrade Advisor scans local report servers only.

Components
Select the components to analyze. You can click the Detect button to select all the components installed on the computer. A check mark will appear next to the components that are detected as installed on the computer. You can also manually select the components to analyze by selecting or clearing the check box next to each component.

See Also

Working with Upgrade Advisor
Upgrade Advisor User Interface Reference