Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Server Configuration How-to Topics

The default settings for server components allow you to run an instance of Microsoft SQL Server immediately after installation. In most cases, you do not need to reconfigure the server. However, server management is necessary in those situations where you want to set up special server configurations, change the network connections, or set server configuration options to improve SQL Server performance.

Server properties can be managed from SQL Server Management Studio, and SQL Server Configuration Manager. Many properties are read-only. Some server properties can only be changed using the correct tool. Some server properties require a restart of SQL Server before they will take effect.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft