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?