Remove From My Forums

sql 2005 jogosultság probléma

Question
0

Sign in to vote

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

Segítsetek nekem ezt elhárítani pls.

NAgyon köszönök minden hozzászólást.

Thursday, June 14, 2007 9:56 AM

Answers

0

Sign in to vote

Nagyon köszönöm a segítséget, megoldódott a problémám 1 pipa bekattintásával. sql server 2005 -> Surface Area configuration -> enable openrowset

Köszi még egyszer!

Thursday, June 14, 2007 3:41 PM

All replies

0

Sign in to vote

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure ‘Ad Hoc Distributed Queries’, 1;
GO
RECONFIGURE;
GO

Thursday, June 14, 2007 11:04 AM

Moderator
0

Sign in to vote

Nagyon szépen köszönöm a gyors válaszod, de sajna az alábbi hibaüzenetet dobta:

Msg 5808, Level 16, State 1, Line 1

Ad hoc update to system catalogs is not supported.

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 5808, Level 16, State 1, Line 1

Ad hoc update to system catalogs is not supported.

Thursday, June 14, 2007 12:08 PM
0

Sign in to vote

Nagyon köszönöm a segítséget, megoldódott a problémám 1 pipa bekattintásával. sql server 2005 -> Surface Area configuration -> enable openrowset

Köszi még egyszer!

Thursday, June 14, 2007 3:41 PM
0

Sign in to vote

Az egyik idézőjel rossz volt, így a helyes:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

Friday, June 15, 2007 12:18 PM

Moderator