Enabling SQL Server 2008 (R2) access over Network

Enabling SQL Server 2008 (R2) access over Network

SQL Browser Service

• Click on Start Run Services.MSC
• Set SQL Server Browser Service to automatic and start SQL browser service.

SQL Network Configuration 

• Open SQL Server Configuration Manager Expand SQL Server Network Configuration and click Protocols for MSSQLSERVER
• Double click TCP/IP
• Set Enabled to Yes

Thanks to Rajesh H