Remote connection trough VPN not working

Posted on 2008-02-10
Medium Priority
Last Modified: 2008-02-28
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.

Question by:David MacDonald

Accepted Solution

Vgan earned 500 total points
ID: 21007436
To connect to a SQL 2005 named instance you must also have SQL Server Browser running and active.

You get to that through SQL Server Configuration Manager /  SQL Server 2005 Services.   If it isn't running then start it.  If it is running make sure it is active by right clicking and selecting properties.  Then go to the Advanced tab and make sure Active is set to "YES".  If you have to start the service then you might want to change it to automatic start.  If you have to change any settings then you may have to reboot the computer as all too often, restarting the SQL server engine alone isn't enough, even when it indicates that is all that is needed.

You may also have to set up an alias on each client using the Run - cliconfg.exe program.  sometimes setting up the Aliases on the the server are enough but named instances are a lot more complicated than default instances.

Good Luck

Author Comment

by:David MacDonald
ID: 21007563
Hi VGan,
          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 !

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question