What is SQL Server – Using Configuration Manager in SQL 2008


In this SQL server training, we go over SQL server Configuration Manager. This is an important tool that can let you start, stop, pause and resume MSSQL Services. These include the database engine (MSSQLSERVER), SQL Server 2008 Agent, integration services (SSIS), reporting services (SSRS). SQL Configuration Manager also gives you the ability to setup dedicated Windows account for SQL Services and also configure SQL services to start automatically or manually.

In addition you are able to configure network configuration and client configuration in SQL server 2008. This will include things like communication protocols including shared memory, named pipes and TCPIP. In addition, you can also set up IP addresses, aliases for your SQL server.