Can we access the Microsoft SQL Server database in the WAN?

Question

I just want to ask if we can access the Microsoft SQL Server database in the WAN, for example, in my SQL database? If so, kindly guide me how?

Thanks at Advance.

Answer 1

Q: Can you access MSSQL through the WAN?

A: Short answer: Yes.

In theory, you can access MSSQL anywhere in the network, including through the WAN.

All you need is:

• route between your client and the MSSQL server and

• The MSSQL port must be open (usually TCP port 1433).

If you can "ping" from your client to a remote host, you will get 1) covered.

To "open a port", you must:

a. Configure the MSSQL server to use TCP / IP (this is optionally enabled by default)

b. Open port 1433 on the MSSQL server host

with. Configure a router between your client and host to open port 1433, and request a route on that port to your MSSQL Server

e. Configure any firewalls (including your client PC) to allow port 1433

Here is the link to open the Windows Firewall:

• https://msdn.microsoft.com/en-us/library/cc646023.aspx

Here is the link to configure your router (s):

• https://technet.microsoft.com/en-us/library/ms175483%28v=sql.105%29.aspx