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.

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

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

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