Data Migration Assistant SQL Server to Azure VIEW Server State

Question

I was trying to migrate my SQL database to Azure SQL using a data migration tool. I have a SQL server 2012 version. While selecting the target section it throws the following error:

VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action. And can go no further.

Can anyone help me with this?

Answer 1

So basically, there are two ways which you cna try to rectify this error:

1. Using SQL server management server:

- First, connect tp your on-prem SQL.

- Then, you need to select new Query and perform this query:

GRANT VIEW SERVER STATE TO "AccountName"

2. Try to update your SSMS into a newer version.

I hope this will help.

Want to become an Azure Expert? join azure certification now!!