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