Remote connection trough VPN not working
Posted on 2008-02-10
HI there, I have two SQL 2005 instance, one on a laptop, let's call it GBE and another on VM. Each of these laptop have a second network interface created with OPenVPN to isolate them in a nice ans cozy VPN. Both are running XP Pro btw.
The laptop GBE has a named instance of 2005 since there is a instance of SQL2000 already on it. My problem is, none of these to can connect to each others database.
I have a third machine wich has a clean install on Windows 2k3, also part of the VPN, on wich there is also a sql2005 default instance, to wich everyone can connect.
How can one remotely connect to a SQL2005 instance without having the dreaded 'remote connection not set' error ?
TCP/IP connection are turned on in each Surface area configuration ... is sql2000 interfering with sql2005 on the gbe laptop ? If yes what can i do.
There are no firewalls activated
MSDTC is configured to permit everything
Averything is connected in a VPN while being a member of it's own network ( 2 Network interface )
I post this question out of despair, having tried so many config that i'm starting from scratch, and hopefully, some help from friendly experts.