Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in Azure by (13.1k points)

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?

1 Answer

0 votes
by (26.7k points)

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!!

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...