Validation errors in the source server.
Applies to: Azure SQL Database, Microsoft Data Migration Assistant (DMA) v3.3.
Problem Description.
A user was trying to use
Microsoft Data Migration Assistant (DMA) to migrate a local (on-premise)
SQL Server database to an Azure SQL Database server, but when he provided the
credentials to connect to the source SQL Server instance he received from DMA
the following errors:
There are validation errors in the source server. Please fix the issues and go
to the next step.
Invalid source server details were specified for the migration. Validator
'Microsoft.SqlServer.Migration.Core.Validators.SupportedDatabaseEnvironmentValidator'
failed to validate data. A connection was successfully established with the
server, but then an error occurred during the login process. (provider: SSL
Provider, error: 0 - The certificate chain was issued by an authority that is
not trusted.) The certificate chain was issued by an authority that is not
trusted
Solution.
Please, make a click on the "Trust server certificate" check box and then click
the Connect button again. You should be able to go to next step.
![[Company Logo Image]](images/SQLCofee.jpg)
