Connect to SQL Server 2005 over VPN

Question

Connect to SQL Server 2005 over VPN

cpmccann

Valued Member

Points: 69
More actions
July 14, 2008 at 5:52 am

#184609

Hi All
SQL newbie for sure.
I have set up replication on SQL 2005 server, have successfully published and subscribed from inside the lan. When I try to connect through a VPN I cannot see the SQL Server. I have tried connect through ODBC but get the following;
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I am working on a VISTA Ultimate Laptop. Firewall turned off.
SQL Server is not on DC but on a separate machine in the domain.
Windows authentication.
Firewall controls the VPN user access. Can get VPN access no problem. Can ping SQL server.
Some questions;
Do I need to have specific ports open on the firewall to allow SQL pass through the VPN tunnel. If so what ports?
Do I need to run RAS on the Domain Controller and enable ports using pptp?
Thanking you in anticipation.
Conor

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

I have had to do hosts file hacks at times where the VPN wasn't provide DNS resolution properly to be able to connect to a remote server once the VPN was active. When you ping the server, are you pinging the IP or the name?

GSquared SSC Guru Points: 260824 More actions · Answer 2

When I've connected through VPN, I've had to remote-desktop to the server to get Management Studio to connect to the database.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 3

Start by checking firewall settings on both ends. Windows firewall blocks SQL by default I believe, so you have to allow it to come through.