My suggestion is to disable any security software (antivirus, etc) that is preventing a Web Browser to pop up. A browser window is supposed to kick off at first, and some security extensions block that kind of activity.
Collector error on Data Migration Assistant when running assessment

Hi,
I am running DMA on my local dev machine (as an admin), connecting to a locally installed SQL2019 instance, where I am also an SA. When I run an assessment on any database I receive the following error:
The server instance-level assessment of server 'MyServer' failed.
Feature discovery error message: 'There was an unexpected exception when discovering features for server 'MyServer'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.Collectors.ServerPropertiesFeatureCollector' failed to collect data.'.
I'm using the latest DMA tool, running as admin, with admin rights on machine and on SQL instance as mentioned. The localhost machine is a Windows 10 1909 system.
Looking at the DMA logs I can see:
Dma.exe Information: 0 : Completed Action: DiscoverFeaturesAssessmentAdvisor
Dma.exe Information: 0 : Completed Action: If
Dma.exe Information: 0 : Running Action: If
Dma.exe Information: 0 : Completed Action: If
Dma.exe Information: 0 : Running Action: UpdateAssessmentServerInstanceModels
Dma.exe Information: 0 : Unhandled exception reported, ErrorId '9521917315241486963', ExceptionName 'FailedtoDiscoverSourceFeaturesException', Error '0x858E000F', StackFrame '.', WatsonData 'NotSpecified', OuterExceptionName 'ServerAssessmentFailedException', OuterErrorCode '0x86040001', OuterCallSite '.', OuterWatsonData 'NotSpecified'
Dma.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Advisor.Common.Contracts.ServerAssessmentFailedException
Message:
The server instance-level assessment of server 'MyServer' failed.
HResult : 0x86040001
FacilityCode : 1540 (604)
ErrorCode : 1 (0001)
Data:
ServerName = MyServer
DpesErrorReportedId = 9521917315241486963
Inner exception type: Microsoft.SqlServer.Advisor.Workflows.Contracts.FailedtoDiscoverSourceFeaturesException
Message:
Feature discovery error message: 'There was an unexpected exception when discovering features for server 'MyServer'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.Collectors.ServerPropertiesFeatureCollector' failed to collect data.'.
HResult : 0x858E000F
FacilityCode : 1422 (58e)
ErrorCode : 15 (000f)
Data:
ErrorMessage = There was an unexpected exception when discovering features for server 'MyServer'.; Inner excreption message: Collector 'Microsoft.SqlServer.Advisor.Scenarios.FeatureDiscovery.Collectors.ServerPropertiesFeatureCollector' failed to collect data.
'
Dma.exe Information: 0 : The step 'Completed' in activity '45f343d9-9875-4088-a8f1-d8b38ae69211' failed with an unhandled exception with name 'ServerAssessmentFailedException'
Dma.exe Information: 0 : The step 'Completed' in activity '45f343d9-9875-4088-a8f1-d8b38ae69211' had a final outcome of 'Failed'
As this is all running locally, with admin rights everywhere, I'm not sure what could be causing the issue so wondered if anyone from MSFT could advise?
Thanks,
Ben C
2 answers
Sort by: Most helpful
-
Alberto Morillo 26,016 Reputation points MVP
2022-09-06T11:58:24.073+00:00 Seeya Xi-MSFT 14,806 Reputation points Microsoft Vendor2022-09-07T09:30:33.233+00:00 Hi @Ben C ,
Please read this document first to check if there are any non-compliance.
https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.