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

  • Make sure you've:
  • Review app-discovery support and requirements.
  • In case you're discovering assets on VMware environment then, Make sure servers where you're running app-discovery have PowerShell version 2.0 or later installed, and VMware Tools (later than 10.2.0) is installed.
  • Check the requirements for deploying the Azure Migrate appliance.
  • Verify that you have the required roles in the subscription to create resources.
  • Ensure that your appliance has access to the internet

Note

Even though the processes in this document are covered for VMware, the processes are similar for Microsoft Hyper-V and Physical environment. Discovery and assessment for SQL Server instances and databases is available across the Microsoft Hyper-V and Physical environment also.

Enable discovery of 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 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.
    • 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 web apps.
    • Appliance will attempt to validate the Domain credentials with AD, as they're 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 aren't validated.
  3. Once the desired credentials are added, select Start Discovery, to begin the scan.

Note

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