Connection with DMA

Nilesh Patel 111 Reputation points
2021-10-05T11:16:52.967+00:00

While I was connecting my My SQL server 2019 with the DMA tool I'm getting the error.

PFB the error message :

Connection to the server failed.
VIEW SERVER STATE permission was denied on object 'server', database 'master'.
The user does not have permission to perform this action.

And, also attaching the photo of error.137695-microsoftteams-image.png

Azure Database Migration service
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
516 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,126 Reputation points Microsoft Vendor
    2021-10-06T03:10:52.94+00:00

    Hi @Nilesh Patel ,

    > While I was connecting my My SQL server 2019 with the DMA tool I'm getting the error.

    Did your environment is MS SQL server instance? If not, please let us know. DMA is not supported for My SQL server. It seems that you make a spelling mistake.

    If you are using MS SQL server, according to the error message, it stated that you did not have the permission. The user run DMA need to be a member of the SQL Server sysadmin role.

    Using below T-SQL to add login to sysadmin role.

    ALTER SERVER ROLE sysadmin ADD MEMBER Cathy  
    

    Or using SSMS UI as below screenshot. SSMS > security > login >Cathy >properties.

    137956-screenshot-2021-10-06-110629.jpg


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments No comments