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

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

 

 

这个错误初看以为是权限问题,后面验证、检查、查找资料过后,发现这个是一个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

时间: 2024-09-17 04:15:21

VIEW SERVER STATE permission was denied on object 'server', database 'master'的相关文章

Linked Server: EXECUTE permission denied on object 'xp_prop_oledb_provider', database 'master', owner 'dbo'

问题出现环境:         使用SQL Server Management Studio 2008 连接到SQL Server 2000的数据库,点击其中一个Oracle链接服务器,单击"目录"时,Linked Server弹出如下错误信息.使用另外一个拥有sysadmin角色的账号登录检查发现没有此类问题. 错 误详细信息如下所示:有用的信息只有一条:EXECUTE permission denied on object 'xp_prop_oledb_provider', dat

关于You don t have permission to access / on this server提示总结

仔细检查了一遍配置文件httpd.conf,找到这么一段:  代码如下 复制代码 <Directory />     Options FollowSymLinks     AllowOverride None     Order deny,allow     deny from all     Satisfy all </Directory> 然后试着把deny from all中的deny改成了allow,保存后重起了apache,然后再一测试我的网页 apache 解决Apac

PHP错误:Forbidden You don&#039;t have permission to access / on this server

 今天在测试一个php程序的时候,发现这个问题: Forbidden You don't have permission to access / on this server.   开始的时候我是用http://localhost/test.php进行的测试,没有发现问题,后来要在内网测试一下就要用IP地址进行那个访问了,如:http://10.10.50.195/test.php,就出现了这个问题. 后来咨询了一下朋友(php高手),说修改一下php的配置文件httpd.conf. 在原有的位

You don&#039;t have permission to access / on this server提示 求解决办法~

提示You don't have permission to access / on this server..Apache定义了默认对网站根的访问权限. # Each directory to which Apache has access can be configured with respect # to which services and features are allowed and/or disabled in that # directory (and its subdire

Apache出现You dont have permission to access / on this server解决方法

由于对环境不了解在配置好环境之后Apache出现You don't have permission to access / on this server. 提示  代码如下 复制代码 <Directory />     Options FollowSymLinks     AllowOverride None     Order deny,allow     Deny from all </Directory> 解决办法 把 Deny from all 中的 Deny 改成了All

Forbidden You don&amp;#39;t have permission to access / on this server.

原文:Forbidden You don't have permission to access / on this server.Forbidden You don't have permission to access / on this server. 当出现此问题的时候,记得修改httpd.conf. 在原有的位置文件中找到配置节 <Directory />     Options FollowSymLinks     AllowOverride None     Order deny

PHP错误:Forbidden You don&amp;#39;t have permission to access / on this server.

原文:PHP错误:Forbidden You don't have permission to access / on this server. 今天老大让在xp下搭建一个FTP服务器,一波三折,最后终于在老大的帮助下搞定了... 其中通过ip访问的时候 提示 Forbidden You don't have permission to access / on this server. 找到一个解决方法,特此记录   php的配置文件httpd.conf. 在原有的位置文件中找到配置节 <Dir

WampServer设置apache伪静态出现404 not found及You don&#039;t have permission to access / on this server解决方法分析[原创]_服务器其它

本文实例讲述了WampServer设置apache伪静态出现404 not found及You don't have permission to access / on this server解决方法.分享给大家供大家参考.具体如下: 出现404 not found 时: 确保LoadModule rewrite_module modules/mod_rewrite.so开启 然后 复制代码 代码如下: <Directory />     Options FollowSymLinks    

如何将windows Server 2003中NTBackup恢复到Windws Server 2008/R2

我们在企业环境中经常会遇到系统升级或者数据恢复的问题,有时因为服务器系统版本更新或者更换新系统的服务器时,我们需要把Windows Server 2003中NTBackup中的文件备份恢复到Windows Server 2008或者Windows Server 2008 R2中,但在Windows Server 2008或者Windows Server 2008 R2中系统默认没有Ntbackup功能,取而代之是Windows Server backup功能了,在Windows Server b