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

2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from SQL Configuration Manager 3.