question

NileshPatel-7672 avatar image
0 Votes"
NileshPatel-7672 asked Cathyji-msft commented

Connection with DMA

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


sql-server-migrationazure-database-migrationsql-server-migration-assistant
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NileshPatel-7672,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @NileshPatel-7672,

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.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.