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
- Make sure you've:
- Review app-discovery support and requirements.
- 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
Enable discovery of ASP.NET web apps and SQL Server instances and databases
In your Azure Migrate project, either
- Select Not enabled on the Hub tile, or
- Select Not enabled on any entry in the Server discovery page under SQL instances or Web apps column
To Discover ASP.NET web apps and SQL Server instances and databases follow the steps entailed:
- Select Upgrade, to create the required resource.
- 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
- 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.
Once the desired credentials are added, please select Start Discovery, to begin the scan.
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.