# [Configure Database Engine Instances](configure-database-engine-instances-sql-server.md) # [Database Engine Instances (SQL Server)](database-engine-instances-sql-server.md) ## [Log File Viewer](../../relational-databases/logs/log-file-viewer.md) # [Server Configuration Options (SQL Server)](server-configuration-options-sql-server.md) ## [access check cache Server Configuration Options](access-check-cache-server-configuration-options.md) ## [ad hoc distributed queries Server Configuration Option](ad-hoc-distributed-queries-server-configuration-option.md) ## [affinity Input-Output mask Server Configuration Option](affinity-input-output-mask-server-configuration-option.md) ## [affinity64 Input-Output mask Server Configuration Option](affinity64-input-output-mask-server-configuration-option.md) ## [affinity mask Server Configuration Option](affinity-mask-server-configuration-option.md) ## [affinity64 mask Server Configuration Option](affinity64-mask-server-configuration-option.md) ## [Agent XPs Server Configuration Option](agent-xps-server-configuration-option.md) ## [allow updates Server Configuration Option](allow-updates-server-configuration-option.md) ## [backup checksum default](backup-checksum-default.md) ## [View or Configure the backup compression default Server Configuration Option](view-or-configure-the-backup-compression-default-server-configuration-option.md) ## [blocked process threshold Server Configuration Option](blocked-process-threshold-server-configuration-option.md) ## [c2 audit mode Server Configuration Option](c2-audit-mode-server-configuration-option.md) ## [clr enabled Server Configuration Option](clr-enabled-server-configuration-option.md) ## [clr strict security Server Configuration Option](clr-strict-security.md) ## [common criteria compliance enabled Server Configuration Option](common-criteria-compliance-enabled-server-configuration-option.md) ## [contained database authentication Server Configuration Option](contained-database-authentication-server-configuration-option.md) ## [Configure the cost threshold for parallelism Server Configuration Option](configure-the-cost-threshold-for-parallelism-server-configuration-option.md) ## [Configure the cursor threshold Server Configuration Option](configure-the-cursor-threshold-server-configuration-option.md) ## [cross db ownership chaining Server Configuration Option](cross-db-ownership-chaining-server-configuration-option.md) ## [Database Mail XPs Server Configuration Option](database-mail-xps-server-configuration-option.md) ## [Configure the default full-text language Server Configuration Option](configure-the-default-full-text-language-server-configuration-option.md) ## [Configure the default language Server Configuration Option](configure-the-default-language-server-configuration-option.md) ## [default trace enabled Server Configuration Option](default-trace-enabled-server-configuration-option.md) ## [disallow results from triggers Server Configuration Option](disallow-results-from-triggers-server-configuration-option.md) ## [EKM provider enabled Server Configuration Option](ekm-provider-enabled-server-configuration-option.md) ## [external scripts enabled Server Configuration Option](external-scripts-enabled-server-configuration-option.md) ## [filestream access level Server Configuration Option](filestream-access-level-server-configuration-option.md) ## [Configure the fill factor Server Configuration Option](configure-the-fill-factor-server-configuration-option.md) ## [ft crawl bandwidth Server Configuration Option](ft-crawl-bandwidth-server-configuration-option.md) ## [ft notify bandwidth Server Configuration Option](ft-notify-bandwidth-server-configuration-option.md) ## [PolyBase Connectivity Configuration (Transact-SQL)](polybase-connectivity-configuration-transact-sql.md) ## [in-doubt xact resolution Server Configuration Option](in-doubt-xact-resolution-server-configuration-option.md) ## [Configure the index create memory Server Configuration Option](configure-the-index-create-memory-server-configuration-option.md) ## [lightweight pooling Server Configuration Option](lightweight-pooling-server-configuration-option.md) ## [Configure the locks Server Configuration Option](configure-the-locks-server-configuration-option.md) ## [Configure the max degree of parallelism Server Configuration Option](configure-the-max-degree-of-parallelism-server-configuration-option.md) ## [max full-text crawl range Server Configuration Option](max-full-text-crawl-range-server-configuration-option.md) ## [Configure the max text repl size Server Configuration Option](configure-the-max-text-repl-size-server-configuration-option.md) ## [Configure the max worker threads Server Configuration Option](configure-the-max-worker-threads-server-configuration-option.md) ## [Configure the media retention Server Configuration Option](configure-the-media-retention-server-configuration-option.md) ## [Configure the min memory per query Server Configuration Option](configure-the-min-memory-per-query-server-configuration-option.md) ## [Configure the nested triggers Server Configuration Option](configure-the-nested-triggers-server-configuration-option.md) ## [Configure the network packet size Server Configuration Option](configure-the-network-packet-size-server-configuration-option.md) ## [Ole Automation Procedures Server Configuration Option](ole-automation-procedures-server-configuration-option.md) ## [open objects Server Configuration Option](open-objects-server-configuration-option.md) ## [optimize for ad hoc workloads Server Configuration Option](optimize-for-ad-hoc-workloads-server-configuration-option.md) ## [PH timeout Server Configuration Option](ph-timeout-server-configuration-option.md) ## [precompute rank Server Configuration Option](precompute-rank-server-configuration-option.md) ## [Configure the priority boost Server Configuration Option](configure-the-priority-boost-server-configuration-option.md) ## [Configure the query governor cost limit Server Configuration Option](configure-the-query-governor-cost-limit-server-configuration-option.md) ## [Configure the query wait Server Configuration Option](configure-the-query-wait-server-configuration-option.md) ## [Configure the recovery interval Server Configuration Option](configure-the-recovery-interval-server-configuration-option.md) ## [Configure the remote access Server Configuration Option](configure-the-remote-access-server-configuration-option.md) ## [remote admin connections Server Configuration Option](remote-admin-connections-server-configuration-option.md) ## [Configure the remote data archive Server Configuration Option](configure-the-remote-data-archive-server-configuration-option.md) ## [Configure the remote login timeout Server Configuration Option](configure-the-remote-login-timeout-server-configuration-option.md) ## [Configure the remote proc trans Server Configuration Option](configure-the-remote-proc-trans-server-configuration-option.md) ## [Configure the remote query timeout Server Configuration Option](configure-the-remote-query-timeout-server-configuration-option.md) ## [Replication XPs Server Configuration Option](replication-xps-server-configuration-option.md) ## [Configure the scan for startup procs Server Configuration Option](configure-the-scan-for-startup-procs-server-configuration-option.md) ## [Server Memory Server Configuration Options](server-memory-server-configuration-options.md) ## [server trigger recursion Server Configuration Option](server-trigger-recursion-server-configuration-option.md) ## [set working set size Server Configuration Option](set-working-set-size-server-configuration-option.md) ## [show advanced options Server Configuration Option](show-advanced-options-server-configuration-option.md) ## [SMO and DMO XPs Server Configuration Option](smo-and-dmo-xps-server-configuration-option.md) ## [transform noise words Server Configuration Option](transform-noise-words-server-configuration-option.md) ## [Configure the two digit year cutoff Server Configuration Option](configure-the-two-digit-year-cutoff-server-configuration-option.md) ## [Configure the user connections Server Configuration Option](configure-the-user-connections-server-configuration-option.md) ## [Configure the user options Server Configuration Option](configure-the-user-options-server-configuration-option.md) ## [xp_cmdshell Server Configuration Option](xp-cmdshell-server-configuration-option.md) # [View or Change the Default Locations for Data and Log Files (SQL Server Management Studio)](view-or-change-the-default-locations-for-data-and-log-files.md) # [View or Configure Remote Server Connection Options (SQL Server)](view-or-configure-remote-server-connection-options-sql-server.md) # [View or Change Server Properties](view-or-change-server-properties-sql-server.md) ## [Server Properties - General Page](server-properties-general-page.md) ### [Server Properties - Memory Page](server-properties-memory-page.md) ### [Server Properties - Processors Page](server-properties-processors-page.md) ### [Server Properties - Security Page](server-properties-security-page.md) ### [Server Properties - Connections Page](server-properties-connections-page.md) ### [Server Properties - Database Settings Page](server-properties-database-settings-page.md) ### [Server Properties - Misc Server Settings Page](server-properties-misc-server-settings-page.md) ### [Server Properties - FILESTREAM Page](server-properties-filestream-page.md) ### [Server Properties - Advanced Page](server-properties-advanced-page.md) # [Soft-NUMA (SQL Server)](soft-numa-sql-server.md) # [Map TCP IP Ports to NUMA Nodes (SQL Server)](map-tcp-ip-ports-to-numa-nodes-sql-server.md) # [Enable the Lock Pages in Memory Option (Windows)](enable-the-lock-pages-in-memory-option-windows.md) # [Manage the Database Engine Services](manage-the-database-engine-services.md) ## [Security Requirements for Managing Services](security-requirements-for-managing-services.md) ## [Configure Windows Service Accounts and Permissions](configure-windows-service-accounts-and-permissions.md) ## [Configure File System Permissions for Database Engine Access](configure-file-system-permissions-for-database-engine-access.md) ## [Run SQL Server With or Without a Network](run-sql-server-with-or-without-a-network.md) ## [SQL Server Browser Service (Database Engine and SSAS)](sql-server-browser-service-database-engine-and-ssas.md) ## [Database Engine Service Startup Options](database-engine-service-startup-options.md) ## [Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service](start-stop-pause-resume-restart-sql-server-services.md) ## [Start SQL Server in Single-User Mode](start-sql-server-in-single-user-mode.md) ## [Start SQL Server with Minimal Configuration](start-sql-server-with-minimal-configuration.md) ## [SCM Services - Connect to Another Computer](scm-services-connect-to-another-computer.md) ### [SCM Services - Set an Instance to Start Automatically](scm-services-set-an-instance-to-start-automatically.md) ### [SCM Services - Prevent Automatic Startup](scm-services-prevent-automatic-startup-of-an-instance.md) ### [SCM Services - Change the Service Startup Account](scm-services-change-the-service-startup-account.md) ### [SCM Services - Configure Server Startup Options](scm-services-configure-server-startup-options.md) ### [SCM Services - Change the Password of the Accounts](scm-services-change-the-password-of-the-accounts-used.md) ### [SCM Services - Configure SQL Server Error Logs](scm-services-configure-sql-server-error-logs.md) # [Change Server Authentication Mode](change-server-authentication-mode.md) # [SQL Writer Service](sql-writer-service.md) # [Broadcast a Shutdown Message (Command Prompt)](broadcast-a-shutdown-message-command-prompt.md) # [Log In to an Instance of SQL Server (Command Prompt)](log-in-to-an-instance-of-sql-server-command-prompt.md) # [Server Network Configuration](server-network-configuration.md) ## [Connect to SQL Server When System Administrators Are Locked Out](connect-to-sql-server-when-system-administrators-are-locked-out.md) ## [Default SQL Server Network Protocol Configuration](default-sql-server-network-protocol-configuration.md) ## [Enable or Disable a Server Network Protocol](enable-or-disable-a-server-network-protocol.md) ## [Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)](configure-a-server-to-listen-on-a-specific-tcp-port.md) ## [Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager)](configure-a-server-to-listen-on-an-alternate-pipe.md) ## [Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager)](enable-encrypted-connections-to-the-database-engine.md) ## [Connect to SQL Server Through a Proxy Server (SQL Server Configuration Manager)](connect-to-sql-server-through-a-proxy-server-sql-server-configuration-manager.md) ## [Configure a Windows Firewall for Database Engine Access](configure-a-windows-firewall-for-database-engine-access.md) ## [Hide an Instance of SQL Server Database Engine](hide-an-instance-of-sql-server-database-engine.md) ## [Configure the Database Engine to Listen on Multiple TCP Ports](configure-the-database-engine-to-listen-on-multiple-tcp-ports.md) ## [Determine Whether the Database Engine Is Installed and Started](determine-whether-the-database-engine-is-installed-and-started.md) ## [Connect to the Database Engine Using Extended Protection](connect-to-the-database-engine-using-extended-protection.md) ## [Register a Service Principal Name for Kerberos Connections](register-a-service-principal-name-for-kerberos-connections.md) # [Client Network Configuration](client-network-configuration.md) ## [Configure Client Protocols](configure-client-protocols.md) ## [Create or Delete a Server Alias for Use by a Client (SQL Server Configuration Manager)](create-or-delete-a-server-alias-for-use-by-a-client.md) ## [Logging In to SQL Server](logging-in-to-sql-server.md) ## [Open the ODBC Data Source Administrator](open-the-odbc-data-source-administrator.md) ## [Check the ODBC SQL Server Driver Version (Windows)](check-the-odbc-sql-server-driver-version-windows.md) # [Troubleshoot Connecting to the SQL Server Database Engine](troubleshoot-connecting-to-the-sql-server-database-engine.md) # [Diagnostic Connection for Database Administrators](diagnostic-connection-for-database-administrators.md) # [SQL Server 2016 Express LocalDB](sql-server-2016-express-localdb.md) # [Remote Servers](remote-servers.md) # [SQL Server Monitor Overview](sql-server-monitor-overview.md) # [Service Broker](sql-server-service-broker.md) # [Buffer Pool Extension](buffer-pool-extension.md)