VIEW SERVER STATE permission was denied on object 'server', database 'master'

时间:2021-03-28 14:48:00

今天一同事反馈使用SQL Server 2012 Management Studio连接SQL Server 2014后,选择数据库中某个表,然后单击右键时,就会遇到下面错误:

VIEW SERVER STATE permission was denied on object 'server', database 'master'

这个错误初看以为是权限问题,后面验证、检查、查找资料过后,发现这个是一个bug来的,需要升级或应用SQL Server Management Studio工具的补丁来解决这个问题。下面链接有描述这个问题的相关资料,特此记录一下,方便遇到此类问题的人查找、检索。

http://dba.stackexchange.com/questions/118452/error-message-view-server-state-permission-was-denied-when-connecting-to-sql

https://connect.microsoft.com/SQLServer/feedback/details/791630/cannot-view-properties-of-database-when-using-db-owner-account