Home
Instance and application configurations
Post-install or post-upgrade
Security configurations
SQL Server
SQL Server
The SQL server must be configured. See the relevant topics in this guide:
Side TOC
Side TOC
Instance and application configurations
Pre-install or pre-upgrade
Post-install or post-upgrade
Security configurations
Application Server
SQL Server
SQL Server - Setting the Scan For Startup Procs server configuration option to 0
SQL Server - Setting the Default Trace Enabled server configuration option to 1
Setting the Ole Automation Procedures server configuration option to 0
Setting the value of the Ad-hoc Distributed Queries server configuration option to 0
Setting the value of the CLR Enabled server configuration option to 0
Setting the value of the Cross DB Ownership Chaining option to 0
Setting the Database Mail XPs server configuration option to 0
Setting the value of the Remote Access server configuration to 0
Setting the Remote Admin Connections server configuration option to 0
Configuring the SQL server to use non-standard ports
Setting the value of the Hide Instance option to Yes for the production SQL server instances
Setting the value of the xp_cmdshell server configuration option to 0
Ensuring that the Maximum number of error log files is set to a value greater than or equal to 12
Ensuring that the Login Auditing option is set to failed logins
Ensuring that the SQL Server Audit is set to capture both the failed and the successful logins
Revoke CONNECT permissions
Drop orphaned users from SQL server databases