Configuring Remote connection to SQL Server

Normally it is recommended to have the SQL server installed on the Local machine were you have to use it, but there are cases were you should install it on another machine and install application which is using SQL on another machine, like using VAMT tools. We can follow the below procedure to configure it.

1. Log on to the server were your current SQL instance in configured. 
2. From the Start menu choose All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools. 
3. In the left-hand pane of the SQL Server Configuration Manager -> expand the SQL Server Network Configuration node. 
4. Select the Protocols for [INSTANCE NAME] node (depends on the name of your SQL instance). 
5. In the right-hand pane, right-click TCP/IP and choose Enable. 
6. Then restart the SQL Server service as below. 
7. In the left-hand pane of the SQL Server Configuration Manager, select SQL Server Services. 
8. In the right-hand pane, right-click the SQL Server service representing your SQL Instance and choose Restart. 
9. Close the SQL Server Configuration Manager.
10. Now from the Windows Start Menu choose All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Management Studio. 
11. In the left-hand pane of the SQL Server Management Studio, right-click on the SQL instance [SERVERNAME]\[INSTANCENAME]and choose Properties. 
12. In the left-hand pane of the Server Properties window, select Connections. 
13. Enable the 'Allow remote connections to this computer' tick box and click OK. 
14. Close the SQL Server Management Studio. 
15. Restart the SQL Server service as mentioned above step 6 to 9.