Why can't VPN users run our applications, none of the apps will connect to SQL? It used to be fine, then some MS certified techy dialed in , trashed our server and left us without a functioning system, I cannot work out how to fix the problem so your help
We have SBS 2003 Premium with SQL 2000.
They corrupted our default SQL so created a new instance, all apps work fine if ran while connected in-house , but VPN users can no longer run and use our SQL apps.
I've telneted to the server IP on port 1433 and I get a repsonse, so it isn't firewall or port settings that is the probelm.
I've installed SP4, which the VPN issue is suposed to be fixed in SP2, but this hasn't made any difference.
I've checked that named pipes has the correct syntax..
and TCP/IP is enabled on port 1433, the old corrupted default instance I have set to port 0 and ticked 'hide server'.
All services such as SQL Browser are running and also the web applications that connect from a co-located server down our dedicated DES VPN (router 2 router) all works fine.
It is ONLY remote users connecting to the SBS server via VPN and that SQL server that cannot be contacted, even the web server
View Complete Post