Since the Configuration Manager was launched directly from the installer, the server and instance names should already be populated for you. Just click the Connect button to get started.

Figure 1. Using SQL Server Configuration Manager to configure FileStream Access. The second method of enabling FileStream is by using the stored procedure "sp_configure". This stored procedure ...

To configure Extended Protection in SQL Server 2008 R2, follow these steps: Open the SQL Server Configuration Manager. Expand Network Configuration. Right-click on Protocols for <Your Instance Name>.

Click "SQL Server Configuration Manager." Select "SQL Server Services" from the left pane and then right-click the server. Choose "Properties" from the context menu. Click "Startup Parameters." ...

To do this, I went to the SQL Server Configuration Manager, expanded the SQL Server Network Configuration, selected Protocols for SQLEXPRESS, right-clicked TCP/IP and selected Enable (Figure 5).

Figure 2. The SQL Server Management Studio interface. After gathering the pertinent information about my database, I verified that I could connect to the database from the local system by bringing up ...