Technology Software

Overview of SQL Server Configuration Manager

Microsoft introduced SQL Server Configuration Manager Tool in SQL Server. This tool can be used to manage all the software Services. It can additionally be utilized to configure network protocols which can be used by the applicationan. Furthermore making use of this tool, you could also manage the client network configurations.

You are able to start the applications Configuration Manager by entering SQLSERVERMANAGER10.msc in the start/run command.

Managing the Application Services:

Using Server Configuration Manager you can Start, Pause, Stop or Resume Server Services such as SQL Server Integration Services, SQL Analysis Services, SQL Server Full Text Search Service, Server Reporting Services, SQL Server Agent Service, Server Browser Services, and SQL Server Database Engine Services etc.

Use of the Application Configuration Manager to Change SQL Server Service Account and to Change Password:

Database Administrators need to always make use of the software Configuration Manager Tool to change and modify the application or to change the password for any of the software Services. The biggest advantage is it executes other configurations for instance setting permissions in the Windows Registry to ensure that the latest account could read the software configurations instantly as soon as it is updated using software Configuration Manager or using Window Management Instrumentation ( WMI ) or the Server Management Objects ( SMO ). The further benefit is it will automatically come into effect instantly without the need to restart the applications Service thereby helping you avoiding the downtime. As a result, it is recommended to avoid the practice of modifying the Server Services account or changing password using SERVICES.MSC.

Managing the Application 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 the Application Network and Client Protocols

Microsoft SQL Server 2005 and higher versions support below mentioned network and client protocols.

1. TCP/IP
2. Named Pipes
3. Shared Memory
4. VIA

The VIA protocol is disfavored in Microsoft SQL Server 2008 and it will be take out in the future versions of the Microsoft database software, therefore avoid applying it in future development.

In the Software Network Protocols as well as in the Software Native Client Protocols you can actually enable and disable a protocol. To permit or enable a protocol right click the protocol after which select Enable option from the drop down list. To deactivate or disable a protocol right click the protocol after which select Disable option from the drop down list. You are required to restart the SQL Service for the modifications to come into effect.

Making use of SQL Configuration Manger you may also force protocol encryption, this also allows you to create and remove alias. To configure force protocol encryption, expand the applications Network Configuration after which you can right click Protocols for after that select Properties. To turn on Force Encryption choose the option Yes from the drop down list and then click OK to save the changes.

Conclusion

Here you have seen exactly how easily one can set up Network / Client Protocols, can modify service accounts or are able to update service account security passwords using SQL Server Configuration Manager.

Leave a reply