如何设置运行RECONFIGURE语句的权限.在SQL Server中 [英] how set permission for run the RECONFIGURE statement. in sql server

问题描述

当我在sql server中执行以下查询时


EXEC sp_configure``显示高级选项''，``1''

重新配置

EXEC sp_configure``临时分布式查询''，``1''

重新配置；

我收到以下错误.
-------------------------------------------------- ---------------------------------
消息15247，级别16，状态1，过程sp_configure，第94行
用户无权执行此操作.
消息5812，第14级，状态1，程序AdHoc，第12行
您没有运行RECONFIGURE语句的权限.
消息15123，级别16，状态1，过程sp_configure，第51行
配置选项临时分布式查询"不存在，或者它可能是高级选项.
消息5812，第14级，状态1，过程AdHoc，第16行
您没有运行RECONFIGURE语句的权限.
-------------------------------------------------- ----------------------------------

When i execute the following query in sql server


EXEC sp_configure ''show advanced options'', ''1''

RECONFIGURE

EXEC sp_configure ''Ad Hoc Distributed Queries'', ''1''

RECONFIGURE;

i got the following error.
-----------------------------------------------------------------------------------
Msg 15247, Level 16, State 1, Procedure sp_configure, Line 94
User does not have permission to perform this action.
Msg 5812, Level 14, State 1, Procedure AdHoc, Line 12
You do not have permission to run the RECONFIGURE statement.
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option ''Ad Hoc Distributed Queries'' does not exist, or it may be an advanced option.
Msg 5812, Level 14, State 1, Procedure AdHoc, Line 16
You do not have permission to run the RECONFIGURE statement.
------------------------------------------------------------------------------------
Pl''s help me?

推荐答案

sysadmin和serveradmin固定服务器角色隐式持有此权限.
您需要成为数据库连接中的其中之一.

The sysadmin and serveradmin fixed server roles implicitly hold this permission.

You need to be one of these on your database connection.

这篇关于如何设置运行RECONFIGURE语句的权限.在SQL Server中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！