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.