Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Lined Servers over a VPN Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 11:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 1:53 PM
Points: 204, Visits: 725
Our client would like to connect to our SQL server through their SQL server using the linked servers. Now, these two SQL servers are in different domains and they would connect with each other over a VPN connection.

Can anyone tell me how can this be achieved or give me some hints?

Any help would be greatly appreciated.

Thanks
Post #1389332
Posted Tuesday, November 27, 2012 12:00 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:31 AM
Points: 3,900, Visits: 7,138
As long as your client authenticates via VPN into your network, they will be granted and assigned a local IP address on your domain...they will have all the rights that have been assigned to their security/account group in your company's Active Directory.

They will most likely need to use the IP address of the database server in order to successfully connect to it (because DNS entries will not be available to them, the SQL Server Name probably won't work for them).

As long as they have a local SQL Server account to login to the database server with (or their AD account/group has access to the database server), they should be a-o-k


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1389361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse