AnsweredAssumed Answered

CIS Benchmark for SQL Server 2014

Question asked by on Oct 12, 2016
Latest reply on Nov 27, 2017 by

Good Morning,

     I am evaluating the CIS Benchmark for SQL Server 2014 against my PI System for impacts. I have a W2K12R2 server with SS 2014 Standard Edition hosting AF 2016 and Coresight 2016. I also have a pair of Data Archive server on the same platform also running SS 2014 Std Ed.


     Many of the settings are compliant right out of the box but there are a few I have concerns with: 2.6 (local/remote execution of stored procedures), 2.10 (enabled/disabled protocols), 2.11 (dynamic port assignment), 2.12 (hiding instance), and 8.1 (disable browser service).


     Do you have any recommendations for these particular settings?