Configuring SQL Server 2012 remote connection

After you successfully installed SQL Server 2012, you need to configure it to enable remote connection.

First, you need to set UDP port for SQL Server 2012. if you have multiple instances on your SQL Server, you need to have individual port for each instances.

• Run SQL Server Configuration Manager.

• Go to SQL Server Network Configuration, choose your sql instance.

• Click on the TCP/IP from the right pane, and select Properties

• Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet, and the Enabled is set to Yes for each connection.

• Under IPAll, make sure that TCP Port is set to 1433. Here 1434 is used because 1433 has been assigned to another instance.

• When you want to connect to SQL Server 2012 instance from your local remotely, using IP address and port instead of named instance.