We are running a SQL Server 2005 Cluster on Windows Server 2003. Today I had to setup a linked server to a provider database server (proberbly something diffrent then SQL Server) and there was no VPN tunnel or anything similar necassary. I assume that the connection is being established through HTTPS and the remote DB server is being queried via XML.
It would be awesome if I could get that to run for us as well. So I did some reading on it and it almost sounds like this could be established with a HTTP Endpoint on the SQL cluster end and then cluster could be accessed by a remote SQL server through a linked server.
Is my assumption correct? If so does someone has some good documentation on how to set something like this up?
Any advice is very welcome.