[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3039
  • Last Modified:

SQL 2008 - is enabling Hoc Distributed Queries' Safe??

My DB guy is getting this message below.  I was wondering, is enabling this feature safe. should  i worry about security with this enabled?

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.
1 Solution
Security implications revolve around your server being used as a means to access other servers or access to an OLE-DB provider that may turn out to be a vulnerability.

Provided all users of your servers are authenticated and audited, enabling this feature should be ok..

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now