November 27, 2012 at 11:16 am
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
November 27, 2012 at 12:00 pm
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; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply