[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

Connect Microsoft SQL Database in DMZ

Hi All,

I do have one Server in DMZ running MS SQL, and I do have one PC in LAN want connect to the MS SQL Server in DMZ, but always connection fail.

Any idea how do I connect to the MS SQL Server in DMZ? What port should I open in Access Rules?

Tut404

0
tut404
Asked:
tut404
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have to open the port 1433 for sql server <-> your pc.
note that you should change the default port (and hence use that port in the firewall rule also) of the sql server, open for that the Network Utilities in the sql server Start Menu
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now