Select the the field next to Specify a Startup Parameter and then enter "-m" -- without the quotes. Click "Add," then "OK." Restart SQL Server to run the instance in single-user mode.

First, it can be configured through SQL Server Configuration Manager. Figure 1 shows a listing of all the SQL Server Services. Right-clicking on the name of the instance, selecting "Properties", and ...

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