SQL Server Configuration Manager - How to Use SQL Server Configuration Manager to Configure Network Protocols
March 05, 2010
Introduction to SQL Server Configuration Manager
SQL Server Configuration Manager Tool was introduced in Microsoft SQL Server 2005. This tool can be used to manage all the SQL Server Services; it can also be used to configure network protocols that can be used by an SQL Server Instance. Moreover using this tool you can even manage the client network configurations.
You can open SQL Server 2005 Configuration Manager by typing SQLSERVERMANAGER.msc in the run command and to open SQL Server 2008 Configuration Manager you need to type SQLSERVERMANAGER10.msc in the run command.
Managing SQL Server Services
Using SQL Server Configuration Manager you can Start, Stop, Pause or Resume SQL Server Services such as SQL Server Integration Services, SQL Server Full Text Search Service, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Database Engine Services, SQL Server Agent Service, SQL Server Browser Services etc.
Why one should Use SQL Server Configuration Manager to Change SQL Server Service Account or to Change Password?
Database Administrator should always use SQL Server Configuration Manager Tool to change SQL Server Service Account or to change the password for any of the SQL Server Services. The biggest advantage is; it performs additional configurations such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings immediately once it is changed using SQL Server Configuration Manager or SQL Server Management Objects (SMO) or using Window Management Instrumentation (WMI). The other advantage is it will come into effect immediately without the need to restart the SQL Server Service thereby helping you avoiding the downtime. Hence, you should always avoid the practice of changing the SQL Server Services account or changing password using SERVICES.MSC.
Managing SQL Server and Client Network Protocols
Database Administrator can use SQL Server Configuration Manager to configure server and client network protocols and also to change the connectivity options.
Supported SQL Server Network and Client Protocols
Microsoft SQL Server 2005 and higher versions support below mentioned network and client protocols.
1. Shared Memory
2. Named Pipes
Notes: The VIA protocol is deprecated in Microsoft SQL Server 2008 and it will be removed in the future versions of Microsoft SQL Server, hence avoid using it in future development.
In the below snippet you could see the SQL Server Network Protocols. To enable a protocol right click the protocol and then select Enable option from the drop down list. To disable a protocol right click the protocol and then select Disable option from the drop down list. You need to restart the SQL Server Service for the changes to come into effect.
In the below snippet you could see the SQL Server Native Client Protocols. To enable a protocol right click the protocol and then select Enable option from the drop down list. To disable a protocol right click the protocol and then select Disable option from the drop down list.
Using SQL Server Configuration Manger you can also force protocol encryption, it also allows you to create or remove alias.
To configure force protocol encryption, expand SQL Server Network Configuration and then right click Protocols for
In this article you have seen how easily one can configure Network / Client Protocols, can change service accounts or can update service account passwords using SQL Server Configuration Manager.
Continue Free Learning...
Geeks who read this article also read…
- How to Identify Currently Used SQL Server Authentication Mode
- How to identify if the database was upgraded from a previous version of SQL Server
- How to Get Exclusive Access to SQL Server Database
- Understanding SQL Server Recovery Models
- Changing Default SQL Server Backup Folder in SQL Server 2008
- Changing the default location of SQL Server Data and Log files
- Enforce Password Policies and Password Expiration for SQL Server Logins
- How to Backup an Analysis Services Database Using SQL Server Management Studio
- How to Delete Duplicate Records from an SQL Server Table
- Auditing SQL Server Logins
- New Date and Time Data Types in SQL Server 2008
- Date and Time Functions in SQL Server 2008
- How to Remotely Shutdown, Restart or Log Off Windows Server across the network
- Configuring Database Instant File Initialization Feature of SQL Server
- Microsoft SQL Server Build Versions
- Database Backup Compression Feature In SQL Server 2008
- Read More SQL Server Articles…