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 ...

One of the most useful features in Microsoft System Center Operations Manager is its reporting engine. Installing it can get a little tricky, though. Here's a step-by-step guide.

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>.

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).