Re: Access SQL Server Express over the Internet

PeteDaMeat wrote :
"yannis" <none@xxxxxxxxxx> wrote in message news:mn.cbd47d7a474c7596.0@xxxxxxxxxxxxx
Please answer the following.
1) where is The server located? (static, dynamic IP)
2) Is there any router in bewtween?
3) Any firewall?

1) Dynamic Ip
2) Yes there is a router with a firewall.

You need a service like dynDNS which will be always informed for the current public IP of the server. You will have to use a DNS client I think that Indy has one to retreive the current IP from the client application.

Now on the server you need to instruct the firewall to allow connection on port 1433 and on the router you need to set a NAT on Port 1433 in to the internal Network IP where the server answers which must be static.

I am sorry I was not very clear when I say the Server IP I mean the IP assigned to your router from your ISP this will help to be static but no required if you can find the current IP in a way or an other.

The SQL IP where SQL I mean the Computer that the SQL is installed and holds the Databases MUST be static internaly otherwise the NAT will work until the next reboot or something in which case you will be forced to reconfigure the NAT.

Regards
Yannis.


.

Relevant Pages

  • Re: loss of SOME connectivity
    ... I "think" it is DNS. ... Yes, I can ping the router, AND the ISP DNS. ... I cannot connect the inet cable directly to the server because the inet is ... MS firewall not started. ...
    (microsoft.public.windows.server.sbs)
  • Re: IP Addressing
    ... Address of the ISA server? ... firewall and router). ... On the firewall create a static NAT entry as I wrote ...
    (comp.dcom.sys.cisco)
  • Re: Still cant connect to RWW or OWA remotely
    ... Re-running the CEICW, disabling the firewall, then re-running CEICW again, ... "Cannot find server or DNS Error". ... the DSL router 4-port switch. ... of the two NICs by clicking the Advanced tabs, ...
    (microsoft.public.windows.server.sbs)
  • Re: VPN suggestions requested
    ... > connecting to the Internet through a cheap basic broadband router. ... necessarily mean you have to pop in a firewall, ... also mean only to secure the W2K server. ...
    (comp.security.firewalls)
  • DLink 704 hangs, so I need something better
    ... I recently purchased a DLink 704 firewall/router to hold the static IP ... It works well as a standalone firewall, ... Every consumer-level router in the world has this feature. ... Can Windows 2000 Server perform the same type ...
    (comp.security.firewalls)