How can I configure SQL Server on a remote computer?

While you can configure SQL Server to run on a remote computer, you should only do this if you are an advanced SQL user.

If you install SQL Server on a remote computer, there two things you will need to configure differently from a local computer:

  • Enable TCP/IP for your SQL instance; and

  • Open port 1433 on your firewall.

Follow the configuration instructions provided by Microsoft or your Microsoft Certified Partner to configure TCP/IP and open port 1433.