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 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 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. 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 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