DMA migration

Question

DMA migration

Prakash M, Bhanu 211

Getting this error while connecting azure target server with DMA. Please suggest.

Failed to discover databases for server 'servername.database.windows.net'.
VIEW DATABASE PERFORMANCE STATE permission denied in database 'master'.
The user does not have permission to perform this action.

GeethaThatipatri-MSFT 29,592 Reputation points Microsoft Employee Moderator

2022-06-20T16:52:17.247+00:00

@Prakash M, Bhanu I have not heard back from you. Did my answer helpful.if you find my reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.
Regards
Geetha

2 answers

Your answer

GeethaThatipatri-MSFT 29,592 Reputation points Microsoft Employee Moderator

2022-06-20T16:52:17.247+00:00

@Prakash M, Bhanu I have not heard back from you. Did my answer helpful.if you find my reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.
Regards
Geetha

Answer 1

GeethaThatipatri-MSFT 29,592 Microsoft Employee Moderator

Hi, @Prakash M, Bhanu Thanks for the question and for using the MS Q&A platform.
As per my understanding, you are facing an issue while connecting the Azure target server using DMA.
Errors suggest the SQL login that you are using does not have permissions to run the TSQL
does the login have a sysadmin role assigned?
You can check this document on how to assign and give it a try.

Please let me know if you find any issues or need any additional information

Regards
Geetha

Prakash M, Bhanu 211 Reputation points

2022-06-08T09:50:15.077+00:00

It is Azure Target server. We won't have login properties to provide the sysadmin.

Also we have been told that we are having sysadmin permissions only.

Will DMA only accepts server admin from Azure target server?
GeethaThatipatri-MSFT 29,592 Reputation points Microsoft Employee Moderator

2022-06-09T14:31:55.433+00:00

@Prakash M, Bhanu Sorry for the delay in my response
yes, we have to use the admin user that you used for creating the server that is the easiest path.

Please find this document for reference
please let me know if you have any additional questions

Regards
Geetha
GeethaThatipatri-MSFT 29,592 Reputation points Microsoft Employee Moderator

2022-06-13T18:38:05.39+00:00

@Prakash M, Bhanu I have not heard back from you. Did my answer helpful.if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha

Answer 2

jassi09 26

I am hitting the same issue with dma migration from on-prem to azure. my account has db manager permission.

Share via

DMA migration

2 answers

Your answer