Ensure ‘Hide Instance’ option is set to ‘Yes’ for Production SQL Server instances Details Non-clustered SQL Server instances within production environments should be designated as hidden to prevent advertisement by the SQL Server...
Ensure ‘Maximum number of error log files’ is set to greater than or equal to ’12’ Details SQL Server error log files must be protected from loss. The log files must be backed up before they...
Ensure SQL Server is configured to use non-standard ports Details If enabled, the default SQL Server instance will be assigned a default port of TCP:1433 for TCP/IP communication. Administrators...
Ensure the SQL Server’s Full-Text Service Account is Not an Administrator Details The service account and/or service SID used by the MSSQLFDLauncher service for a default instance or MSSQLFDLauncher$ service for...
Ensure the SQL Server’s MSSQL Service Account is Not an Administrator Details The service account and/or service SID used by the MSSQLSERVER service for a default instance or MSSQL$ service for...
Ensure the SQL Server’s SQLAgent Service Account is Not an Administrator Details The service account and/or service SID used by the SQLSERVERAGENT service for a default instance or SQLAGENT$ service for...
Ensure Unnecessary SQL Server Protocols are set to ‘Disabled’ – ‘Named Pipes protocol is disabled’ Details SQL Server supports Shared Memory, Named Pipes, TCP/IP and VIA protocols. However, SQL Server should be configured to use...
Ensure Unnecessary SQL Server Protocols are set to ‘Disabled’ – ‘Shared Memory protocol is enabled’ Details SQL Server supports Shared Memory, Named Pipes, TCP/IP and VIA protocols. However, SQL Server should be configured to use...
Ensure Unnecessary SQL Server Protocols are set to ‘Disabled’ – ‘TCP/IP protocol is disabled’ Details SQL Server supports Shared Memory, Named Pipes, TCP/IP and VIA protocols. However, SQL Server should be configured to use...
Ensure Unnecessary SQL Server Protocols are set to ‘Disabled’ – ‘VIA protocol is disabled’ Details SQL Server supports Shared Memory, Named Pipes, TCP/IP and VIA protocols. However, SQL Server should be configured to use...