MSSQL 2005 Remote Connections

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I have an XP pro machine, that I have MSSQL 2005 installed.

I have a fixed ip for my internet connection, which comes in to an
router, where the ports 1040 1433 1434 are forwarded from the router
to the mssql server machine (192.168.1.4). As I am having numerous
problems with this, I have enabled DMZ and pointed it to 192.168.1.4.
And I have disabled all the firewalls on the machine and on router
just in order to get this (bleeding thing) working.

How ever I am unable to connect to the MSSQL 2005 database from
outside of the LAN. With in the lan of course it is connecting fine. I
have changed all the settings on the services to allow remote
connections to the server.

Can anyone else think of anything that I am missing here?

I ran some other services on the machine and forwarded those port to
the same server and they work fine from outside of the network. This
tells me that this is something to do with the MSSQL 2005 settings.

Any, help will be most appreciated.

Cheers

CJ

.

Relevant Pages

  • Re: static routing
    ... Connections work going out from inside the router, ... I'll have to remove the router and connect the server directly to the cable ... A static route has been added that matches the subnet ...
    (microsoft.public.windows.server.networking)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Networking Question - VLANs on SBS 2003 Premium SP1
    ... port on the old router so I now have a segregated WLAN. ... be sure you do not enable any DHCP server in internal network. ... On the Connection Type page, click Broadband, and then click Next. ... On the Network Connection, You must enable and configure the network ...
    (microsoft.public.windows.server.sbs)
  • Re: Urgent! New router and big disaster
    ... seleting full time broadband connection. ... Les Connor [SBS Community Member - SBS MVP] ... check the router as well and unless I missed a firewall setting on it, ... Anyway the Server Ipconfig /all is this... ...
    (microsoft.public.windows.server.sbs)
  • Re: Still cant connect to RWW or OWA remotely
    ... As for error messages when I fail to access RWW with the laptop, ... the server) when you fail to access RWW with the laptop? ... I tried accessing RWW from my laptop connected to a router ... match the broadband connection, the two NIC firewall, the remote ...
    (microsoft.public.windows.server.sbs)