·
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
SQL Server Configuration Manger: http://technet.microsoft.com/en-us/library/ms174212.aspx
Protocol Encryption:
http://technet.microsoft.com/en-us/library/ms191192.aspx
Account Permissions: http://msdn.microsoft.com/en-us/library/ms143504.aspx
