David MacDonald
asked on
Remote connection trough VPN not working
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.
Some pointers:
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.
Regards
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.
Some pointers:
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.
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i finally had figured it out by myself and had forgotten to delete the question. I needed in fact to reboot the machines after activated SQLBrowser. I also had messed up the listening comm. ports of SQLBrowser by testing for a solution, I put them back to automatic configuration.
I'll award you the points since no one answered this, and you tipped me with the aliases, wich i did'nt really know about.
Regards !