Linked SQL Servers via a VPN connection?

[StevenK]

Is it possible to set up a linked server from one SQL Server to another via a VPN connection?

I've some vague recollection that his can be done - but can't recall the specifics....

Any advice would be appreciated.
Thanks in advance.
Steve

 

[Catadmin]

You should be able to set up the linked servers as normal from either side of the VPN. You might need to use a shared login account (domain user account with the same name & pwd on both sides), but I'm not sure if that's entirely necessary.

Oh, I think you'll need to allow remote connections on the servers. Other than that, I believe the actual VPN set up takes care of most of the other stuff.


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

As long as you have network connectivity you can setup a linked server. How the network connectivity is setup SQL doesn't care about.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[onpnt]

Just make sure in your particular VPN setup which is typically done by means of restrictive access per connection that you allow the required access that SQL Server needs.

I had a similar situation with our Cisco solution and it turned out the group settings for our connection was disallowing a few port connections killing everything. After working out the concentrator group settings it worked fine as pointed out

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[StevenK]

Is there an on-line guide / walk-through example that I can refer to - to get my bearings with this?
[setting up a linked server from my local SQL Server Enterprise Manager to another instance of SQL Server - accessible via a VPN connection?]
Thanks again.
Steve

 

[onpnt]

without knowing the details of your VPN setup, not really. This wouldn't be the correct forum for that though.

Get your VPN configuration details and then read the manuals or such on any considerations you need to think about when transmitting over it.

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[Catadmin]

As onpnt said, VPN connections are unique to each work place. Get with your network people and discuss the issue with them to make sure you don't have firewall ports closed off that you may need access through and that the group policies don't prevent anything you need to do.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"