Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server...
How do you say "Trust your struggle." in French?
Is there any common country to visit for persons holding UK and Schengen visas?
Trouble reading roman numeral notation with flats
Should a narrator ever describe things based on a character's view instead of facts?
Is there a page on which I can view all Sitecore jobs running?
Reasons for having MCU pin-states default to pull-up/down out of reset
Can you take a "free object interaction" while incapacitated?
"Oh no!" in Latin
What do the positive and negative (+/-) transmit and receive pins mean on Ethernet cables?
Why would five hundred and five same as one?
Would this string work as string?
Writing in a Christian voice
Do people actually use the word "kaputt" in conversation?
How to evaluate the research level of a paper before any publication?
New Order #2: Turn My Way
is this saw blade faulty?
Are hand made posters acceptable in Academia?
I keep switching characters, how do I stop?
Taking the numerator and the denominator
What's the meaning of "what it means for {something} to be {something}"?
Make a Bowl of Alphabet Soup
How can an organ that provides biological immortality be unable to regenerate?
How to get directions in deep space?
Highest stage count that are used one right after the other?
Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio
Login failed for user 'domainusername'. (Microsoft SQL Server, Error: 18456)SQL Server Management Studio Express 2012 “ONLY”Full-Text Index menu option not appearing in SQL Server Management Studio AND error when right clicking a tableSQL Server Management Studio 2014 Backup - Set Property Devices ErrorSQL Server 2014 and SQL Server 2014 Management StudioSQL Server performance is slow when migrated from SQL Server 2012 to SQL Server 2014view server state permission was deniedSQL Server 2014 Management Studio Backup errorHow to fix SQL Server Management Studio 2014 IntelliSense when intermittentUnable to attach database to Amazon RDS using SQL Server Management Studio 2016Error when upgrading SQL Server from 2012 (sp3) to 2014
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?
sql-server sql-server-2012 sql-server-2014 ssms connectivity
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
add a comment |
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?
sql-server sql-server-2012 sql-server-2014 ssms connectivity
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
add a comment |
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?
sql-server sql-server-2012 sql-server-2014 ssms connectivity
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
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?
sql-server sql-server-2012 sql-server-2014 ssms connectivity
sql-server sql-server-2012 sql-server-2014 ssms connectivity
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
edited 5 mins ago
marcello miorelli
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
asked Oct 19 '15 at 11:18
marcello miorellimarcello miorelli
5,9162062141
5,9162062141
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Just for reference, this problem seems to be related to this Connect bug:
Cannot view properties of database when using db owner account - by Jimmy Rudley
Posted by Microsoft on 7/9/2013 at 2:47 PM
[...] We have corrected this for the next version of SQL 14.
Walter A Jokiel, Program Manager, SQL Server
I have the same problem with SQL Server 2012 Management Studio 2012.
If anyone finds themselves stuck with this problem, try to update SQL Server Management Studio. This way, you don't need to grant the permission VIEW SERVER STATE to the user.
Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone.
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
answered Jun 16 '16 at 14:46
tabordataborda
9611
add a comment |
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 <user_name>
answered Nov 5 '15 at 16:07
StingSting
2,252416
add a comment |
You will get this error message if the user was granted SELECT on single tables.
You will not run into this problem when user is member of db_datareader.
I don't like the idea of granting VIEW SERVER STATE to standard users.
This bug still exists in SSMS 17.1
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
2
I cannot confirm that. Right now I am a member ofdb_datareaderon one such 2012 server, and getting this error. No table level permissions have been granted.
– ajeh
Nov 7 '17 at 19:59
add a comment |
protected by Community♦ Oct 12 '17 at 4:57
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Just for reference, this problem seems to be related to this Connect bug:
Cannot view properties of database when using db owner account - by Jimmy Rudley
Posted by Microsoft on 7/9/2013 at 2:47 PM
[...] We have corrected this for the next version of SQL 14.
Walter A Jokiel, Program Manager, SQL Server
I have the same problem with SQL Server 2012 Management Studio 2012.
If anyone finds themselves stuck with this problem, try to update SQL Server Management Studio. This way, you don't need to grant the permission VIEW SERVER STATE to the user.
Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone.
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
answered Jun 16 '16 at 14:46
tabordataborda
9611
add a comment |
Just for reference, this problem seems to be related to this Connect bug:
Cannot view properties of database when using db owner account - by Jimmy Rudley
Posted by Microsoft on 7/9/2013 at 2:47 PM
[...] We have corrected this for the next version of SQL 14.
Walter A Jokiel, Program Manager, SQL Server
I have the same problem with SQL Server 2012 Management Studio 2012.
If anyone finds themselves stuck with this problem, try to update SQL Server Management Studio. This way, you don't need to grant the permission VIEW SERVER STATE to the user.
Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone.
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
answered Jun 16 '16 at 14:46
tabordataborda
9611
add a comment |
Just for reference, this problem seems to be related to this Connect bug:
Cannot view properties of database when using db owner account - by Jimmy Rudley
Posted by Microsoft on 7/9/2013 at 2:47 PM
[...] We have corrected this for the next version of SQL 14.
Walter A Jokiel, Program Manager, SQL Server
I have the same problem with SQL Server 2012 Management Studio 2012.
If anyone finds themselves stuck with this problem, try to update SQL Server Management Studio. This way, you don't need to grant the permission VIEW SERVER STATE to the user.
Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone.
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
answered Jun 16 '16 at 14:46
tabordataborda
9611
Just for reference, this problem seems to be related to this Connect bug:
Cannot view properties of database when using db owner account - by Jimmy Rudley
Posted by Microsoft on 7/9/2013 at 2:47 PM
[...] We have corrected this for the next version of SQL 14.
Walter A Jokiel, Program Manager, SQL Server
I have the same problem with SQL Server 2012 Management Studio 2012.
If anyone finds themselves stuck with this problem, try to update SQL Server Management Studio. This way, you don't need to grant the permission VIEW SERVER STATE to the user.
Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone.
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
answered Jun 16 '16 at 14:46
tabordataborda
9611
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
edited Oct 12 '17 at 5:01
Paul White♦
53.2k14284457
53.2k14284457
answered Jun 16 '16 at 14:46
tabordataborda
9611
answered Jun 16 '16 at 14:46
tabordataborda
9611
answered Jun 16 '16 at 14:46
tabordataborda
9611
9611
add a comment |
add a comment |
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 <user_name>
answered Nov 5 '15 at 16:07
StingSting
2,252416
add a comment |
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 <user_name>
answered Nov 5 '15 at 16:07
StingSting
2,252416
add a comment |
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 <user_name>
answered Nov 5 '15 at 16:07
StingSting
2,252416
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 <user_name>
answered Nov 5 '15 at 16:07
StingSting
2,252416
answered Nov 5 '15 at 16:07
StingSting
2,252416
answered Nov 5 '15 at 16:07
StingSting
2,252416
answered Nov 5 '15 at 16:07
StingSting
2,252416
2,252416
add a comment |
add a comment |
You will get this error message if the user was granted SELECT on single tables.
You will not run into this problem when user is member of db_datareader.
I don't like the idea of granting VIEW SERVER STATE to standard users.
This bug still exists in SSMS 17.1
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
2
I cannot confirm that. Right now I am a member ofdb_datareaderon one such 2012 server, and getting this error. No table level permissions have been granted.
– ajeh
Nov 7 '17 at 19:59
add a comment |
You will get this error message if the user was granted SELECT on single tables.
You will not run into this problem when user is member of db_datareader.
I don't like the idea of granting VIEW SERVER STATE to standard users.
This bug still exists in SSMS 17.1
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
2
I cannot confirm that. Right now I am a member ofdb_datareaderon one such 2012 server, and getting this error. No table level permissions have been granted.
– ajeh
Nov 7 '17 at 19:59
add a comment |
You will get this error message if the user was granted SELECT on single tables.
You will not run into this problem when user is member of db_datareader.
I don't like the idea of granting VIEW SERVER STATE to standard users.
This bug still exists in SSMS 17.1
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
You will get this error message if the user was granted SELECT on single tables.
You will not run into this problem when user is member of db_datareader.
I don't like the idea of granting VIEW SERVER STATE to standard users.
This bug still exists in SSMS 17.1
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
edited Oct 12 '17 at 4:57
Paul White♦
53.2k14284457
53.2k14284457
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
answered Oct 11 '17 at 14:28
Matthias ElfleinMatthias Elflein
6613
6613
2
I cannot confirm that. Right now I am a member ofdb_datareaderon one such 2012 server, and getting this error. No table level permissions have been granted.
– ajeh
Nov 7 '17 at 19:59
add a comment |
2
I cannot confirm that. Right now I am a member ofdb_datareaderon one such 2012 server, and getting this error. No table level permissions have been granted.
– ajeh
Nov 7 '17 at 19:59
2
2
I cannot confirm that. Right now I am a member of
db_datareader on one such 2012 server, and getting this error. No table level permissions have been granted.– ajeh
Nov 7 '17 at 19:59
I cannot confirm that. Right now I am a member of
db_datareader on one such 2012 server, and getting this error. No table level permissions have been granted.– ajeh
Nov 7 '17 at 19:59
add a comment |
protected by Community♦ Oct 12 '17 at 4:57
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
