Skip to content

Files

Latest commit

vineetvikramvineetvikram
Concept+assessment-calculations_VIVIKRAM_28Jul
Jul 28, 2021
8bc5014 · Jul 28, 2021

History

History
60 lines (48 loc) · 5.2 KB

how-to-discover-sql-existing-project.md

File metadata and controls

60 lines (48 loc) · 5.2 KB
title description author ms.author ms.manager ms.topic ms.date
Discover SQL Server instances in an existing Azure Migrate project
Learn how to discover SQL Server instances in an existing Azure Migrate project.
vineetvikram
vivikram
abhemraj
how-to
03/23/2021

Discover web apps and SQL Server instances in an existing project

This article describes how to discover web apps and SQL Server instances and databases in an Azure Migrate project that was created before the preview of Azure SQL assessment feature and/or before the preview of Azure App Service assessment feature.

Discovering ASP.NET web apps and SQL Server instances and databases running on on-premises machines helps identify and tailor a migration path to Azure. The Azure Migrate appliance performs this discovery using the Windows OS domain or non-domain credentials or SQL Server authentication credentials that have access to the SQL Server instances and databases running on the targeted servers. This discovery process is agentless that is, nothing is installed on the target servers.

Before you start

Enable discovery of ASP.NET web apps and SQL Server instances and databases

  1. In your Azure Migrate project, either

    • Select Not enabled on the Hub tile, or :::image type="content" source="./media/how-to-discover-sql-existing-project/hub-not-enabled.png" alt-text="Azure Migrate hub tile with SQL and web apps discovery not enabled":::
    • Select Not enabled on any entry in the Server discovery page under SQL instances or Web apps column :::image type="content" source="./media/how-to-discover-sql-existing-project/discovery-not-enabled.png" alt-text="Azure Migrate discovered servers blade with SQL and web apps discovery not enabled":::

  2. To Discover ASP.NET web apps and SQL Server instances and databases follow the steps entailed:

    • Select Upgrade, to create the required resource. :::image type="content" source="./media/how-to-discover-sql-existing-project/discovery-upgrade-appliance.png" alt-text="Button to upgrade the Azure Migrate appliance":::
    • Validate that the services running on the appliance are updated to the latest versions. To do so, launch the Appliance configuration manager from your appliance server and select view appliance services from the Setup prerequisites panel.
      • Appliance and its components are automatically updated :::image type="content" source="./media/how-to-discover-sql-existing-project/appliance-services-version.png" alt-text="Check the appliance version":::
    • In the manage credentials and discovery sources panel of the Appliance configuration manager, add Domain or SQL Server Authentication credentials that have Sysadmin access on the SQL Server instance and databases to be discovered.
    • ASP.NET web apps discovery works with both domain and non-domain Windows OS credentials as long as the account used has local admin privileges on servers. You can leverage the automatic credential-mapping feature of the appliance, as highlighted here.

    Some points to note:

    • Ensure that software inventory is enabled already, or provide Domain or Non-domain credentials to enable the same. Software inventory must be performed to discover SQL Server instances and ASP.NET web apps.
    • Appliance will attempt to validate the Domain credentials with AD, as they are added. Ensure that appliance server has network line of sight to the AD server associated with the credentials. Non-domain credentials and credentials associated with SQL Server Authentication are not validated.

  3. Once the desired credentials are added, please select Start Discovery, to begin the scan.

Note

Please allow web apps and SQL discovery to run for sometime before creating assessments for Azure App Service or Azure SQL. If the discovery of web apps and SQL Server instances and databases is not allowed to complete, the respective instances are marked as Unknown in the assessment report.

Next steps