In the default configuration of new installations of SQL Server, many features are not enabled. SQL Server selectively installs and starts only key services and features, to minimize the number of features that can be attacked by a malicious user. A system administrator can change these defaults at installation time and also selectively enable or disable features of a running instance of SQL Server. Additionally, some components may not be available when connecting from other computers until protocols are configured.
Use SQL Server Configuration Manager to start and stop services, configure the startup options, and enable protocols and other connection options.
To start SQL Server Configuration Manager
On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
Use the SQL Server Services area to start components and configure the automatic starting options.
Use the SQL Server Network Configuration area to enable connection protocols, and connection options such as fixed TCP/IP ports, or forcing encryption.
Use SQL Server Configuration Manager to start and stop services, configure the startup options, and enable protocols and other connection options.
To start SQL Server Configuration Manager
On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
Use the SQL Server Services area to start components and configure the automatic starting options.
Use the SQL Server Network Configuration area to enable connection protocols, and connection options such as fixed TCP/IP ports, or forcing encryption.
Comments