Sql Server configuration manager is the management console introduced in sql server 2005 version.
1) the console can be used to start/ stop the services like integration service, analysis service, full text search service , sql server service, reporting service, sql server agent, sql server browser etc.
2) the console can be used by database administrators to reset passwords & enable/ disable client configuration protocols
3) configuration manager can be opened by running command sqlservermanager.msc in 2005 version & sqlservermanager10.msc in 2008 version
4) services can also be seen by running command services.msc , passwords can also be changed here.
5) how ever it is advised to change password or do any configuration changes from configuration manager as
making any changes will take care of additional configuration settings that add to windows registry entries etc..
6) Client applications can connect to sql server to query database & modify data , they can be configured using client protocols.configuration manager defines what protocols can be used by applications, what ports to be opened for sql server to listen incoming requests & what ip addresses.
Applications with in a network identifies the sql server instance by sending out enumeration object & if an instance is available then sql server browser service recieves it & list the available instances which can be used by application.
the following client protocols are supported by 2008
a) shared memory
b) named pipes
c) TCP/IP
d) VIA
VIA is deprecated in 2008 & one should stop using the protocol as they may not be supported in future versions.
7) we can also enable protocol encryption using the configuration manager. expand sql server network configuration , select the protocol for your instance , right click select properties & turn force encryption to true.
We can also hide the sql server instance using the hide instance option ( refer above diagram ) . when we hide an instance , then sql server browser will not list the instance for the applications to access the sql server.
8) sql server dump files are generated ( .dmp, .mdmp ) when ever the server crashes or faces major issues , we can configure the location of them from configuration manager
9) we can even set up the startup parameters , but in sql server 2008 this is just a row in the Advanced tab , where as in Sql Server Denali , there is a seperate dedicated tab for start up parameters giving enough space for the administrator to modify the parameters with out erroneous entries.
reference : http://msdn.microsoft.com/en-us/library/ms174212.aspx
1) the console can be used to start/ stop the services like integration service, analysis service, full text search service , sql server service, reporting service, sql server agent, sql server browser etc.
2) the console can be used by database administrators to reset passwords & enable/ disable client configuration protocols
3) configuration manager can be opened by running command sqlservermanager.msc in 2005 version & sqlservermanager10.msc in 2008 version
4) services can also be seen by running command services.msc , passwords can also be changed here.
5) how ever it is advised to change password or do any configuration changes from configuration manager as
making any changes will take care of additional configuration settings that add to windows registry entries etc..
6) Client applications can connect to sql server to query database & modify data , they can be configured using client protocols.configuration manager defines what protocols can be used by applications, what ports to be opened for sql server to listen incoming requests & what ip addresses.
Applications with in a network identifies the sql server instance by sending out enumeration object & if an instance is available then sql server browser service recieves it & list the available instances which can be used by application.
the following client protocols are supported by 2008
a) shared memory
b) named pipes
c) TCP/IP
d) VIA
VIA is deprecated in 2008 & one should stop using the protocol as they may not be supported in future versions.
7) we can also enable protocol encryption using the configuration manager. expand sql server network configuration , select the protocol for your instance , right click select properties & turn force encryption to true.
We can also hide the sql server instance using the hide instance option ( refer above diagram ) . when we hide an instance , then sql server browser will not list the instance for the applications to access the sql server.
8) sql server dump files are generated ( .dmp, .mdmp ) when ever the server crashes or faces major issues , we can configure the location of them from configuration manager
9) we can even set up the startup parameters , but in sql server 2008 this is just a row in the Advanced tab , where as in Sql Server Denali , there is a seperate dedicated tab for start up parameters giving enough space for the administrator to modify the parameters with out erroneous entries.
reference : http://msdn.microsoft.com/en-us/library/ms174212.aspx
No comments:
Post a Comment