Sunday 1 December 2013

Configuration Manager

·         Configuration manager is GUI to manage/configure all
§  Sql Server Services,
§  Server Network Protocols,
§  Client Network Configurations
§  And also to change the Connectivity options.



·         Using SQL Server Configuration Manager you can set Service's (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)
                              §  State à   Start OR Stop
§  Start Mode à   Manual OR Automatic


·         Using SQL Server Configuration Manger, allows  you to Create or Remove Server Alias.

·         Using SQL Server Configuration Manger you can also force Protocol Encryption and Protocol’s
§  State à Enabled OR Disabled
(Shared Memory, Named Pipes, TCP\IP and VIA)

·         Using SQL Server Configuration Manager Tool you can change SQL Server Service Account or change the Password for any of the SQL Server Services.

·         Using SQL Server Configuration Manager, changes in Account settings also configure associated additional changes such as Windows Registory settings and account can read the SQL Server settings immediately once changed where as other Tools (SMO and WMI) can not change associated settings which may effect the proper start of service.

·         Using SQL Server Configuration Manager Tool  changes come into effect immediately by avoiding downtime
  
Reference Links

                               http://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx