'Ad HOC distributed queries' - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - SQL Server 2005/Yukon

'Ad HOC distributed queries'

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-27 : 09:12:11

Barb writes "I'm trying to perform a contact lookup from SQL 2005 db to RE7.70.874.0082. When I run my script I receive the following error :

'Msg 15281, Level 16, State 1, Line 1
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.
Msg 50000, Level 16, State 1, Line 118
Error retrieving membership record(s)

Any ideas?"

krayzee
Starting Member

1 Post

Posted - 2006-05-08 : 04:03:41

Try adding the following code in the beginning:

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

and check that you have "Trusted_Connection=yes;" in the connection string :)

Hope it helps

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources