SQL Surface Area Configuration Manager Audit

Question

Post reply

SQL Surface Area Configuration Manager Audit

Welsh Corgi

SSC Guru

Points: 116520
More actions
September 13, 2016 at 8:22 am

#321463

I got audited by Ernst & Young.
They listed the SQL Server Edition as 2008 but it is a 2012 Server.
The instructions provided do not match for 2012.
This is what I got.
C. Configuration and Supporting ProcessesAd-hoc Access to External Databases - SQL Server 2008Disallow ad-hoc access to external database providers.Failure to disable ad-hoc queries may lead to the SQL server being abused as the host for accessing databases from other providers."Provide a screenshot showing that Adhoc Remote Queries are disabled by using the SQL Surface Area Configuration tool.
STEP 1: Click on [Start – Programs – Microsoft SQL Server Management Studio].
STEP 2: Select the database server, and right click on it, select ""Facets""
STEP 3: Select ""Surface Area Configuration"" for Features on Facets View, and take a screenshot for [AdHocRemoteQueriesEnabled] configuration.
"
I'm trying to determine how to do this in 2012.
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

BLOB EATER SSChampion Points: 14609 More actions · Answer 1

Have a look in sp_configure ( show adv. options I think )

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I just want to accomplish the following in SQL Server 2012.

The instructions provided are for SQL Server 2008.

"Provide a screenshot showing that Adhoc Remote Queries are disabled by using the SQL Surface Area Configuration tool.

STEP 1: Click on [Start – Programs – Microsoft SQL Server Management Studio].

STEP 2: Select the database server, and right click on it, select ""Facets""

STEP 3: Select ""Surface Area Configuration"" for Features on Facets View, and take a screenshot for [AdHocRemoteQueriesEnabled] configuration.

"

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

Welsh Corgi (9/13/2016)
I just want to accomplish the following in SQL Server 2012.
The instructions provided are for SQL Server 2008.
"Provide a screenshot showing that Adhoc Remote Queries are disabled by using the SQL Surface Area Configuration tool.
STEP 1: Click on [Start – Programs – Microsoft SQL Server Management Studio].
STEP 2: Select the database server, and right click on it, select ""Facets""
STEP 3: Select ""Surface Area Configuration"" for Features on Facets View, and take a screenshot for [AdHocRemoteQueriesEnabled] configuration.
"

well from the way I read your instructions....just follow them and take the screenshot.....caveat...works in 2016, so unless things changed between 2008>2012 and then back in 2016...you should be good

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

It works on SQL Server 2012. Make sure you choose Surface Area Configuration from the Facet drop-down list in the View Facets window.

John

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I'm doing something wrong for I do not have that option in the drop down list.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 6

Welsh Corgi (9/13/2016)
I'm doing something wrong for I do not have that option in the drop down list.

what does this return

SELECT @@VERSION

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

J Livingston SQL (9/13/2016)
Welsh Corgi (9/13/2016)
I'm doing something wrong for I do not have that option in the drop down list.
what does this return
SELECT @@VERSION

It works. My bad.

Thanks to everyone.:-)

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/