Click here to Skip to main content
15,887,683 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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?
Posted

1 solution

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

You need to be one of these on your database connection.
 
Share this answer
 
Comments
ijaziju 22-Sep-11 2:07am    
@Mehdi Gholam

How set permision for this?
Mehdi Gholam 22-Sep-11 2:14am    
Call your dba he will do it. It requires administrator privileges.
ijaziju 22-Sep-11 2:24am    
i know our administrator login details.....
can you give me the step by step instruction for this?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900