debugsqlModerate
Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio
Viewed 0 times
studioerror2012sqlconnectingmessagepermissionviewdeniedwas
Problem
When right-clicking on a table and selecting "select top 1000 rows", I get this error:
Is there any workaround, other than the obvious upgrade to SQL Server 2014?
Is there any workaround, other than the obvious upgrade to SQL Server 2014?
Solution
The least intrusive way to get this working is to either use the following command or have the DBA issue this command for you:
use master
go
GRANT VIEW SERVER STATE TO Code Snippets
use master
go
GRANT VIEW SERVER STATE TO <user_name>Context
StackExchange Database Administrators Q#118452, answer score: 15
Revisions (0)
No revisions yet.