MS SQL Server - Configuring MS SQL Server for Remote Access

This is repost of this:

Configuring MS SQL Server for Remote Access

Extra info from my experience:

1. If you have more then one SQL server instance make sure that they use different ports.
   Leave first one on 1433 and assign your new one 1434.
2. In IP addressess section IPAII make sure to clear TCP Dynamic ports on the bottom.

When trying to connect using SSMS if you had to use different port from 1433 and have some named instance here is naming convention for SQL server address:

vs2008develop,1434\MSSQLSERVERR2