May 11, 2007 at 4:04 pm
It seems intuitive that a client should be able to interact with a SQL Server 2000 database over a WAN, but I don't know if that's really possible or, if so, what the limitations are.
Specifically, I have a 3rd party application that uses a Windows-based client to index and store electronic documents in a SQL Server database on a LAN. Is there a way for this client to interact with a remote SQL Server database over an Internet connection? Would this depend on the transport/connection protocol(s) involved?
Any feedback on this would be greatly appreciated.
Thanks.
May 11, 2007 at 4:08 pm
You would need to give them a SQL Server authentication login. Then provide them the connection information (Server name or IP Address, instance name, port number). Then make sure that the firewall is set up to allow the connection. That should be all that is needed.
-SQLBill
May 15, 2007 at 9:08 am
For security sake be sure to use a VPN, or some type of encrypted connection.
May 16, 2007 at 6:52 am
Hi,
you need a routable protocol, preferably tcp/ip.
You need a working route to the server.
You need to be able to access the SQL Server port, normally 1433.
As Ron proposed, an accordingly configured VPN will get you there.
You also need to consider the bandwidth of the connection, since document storage and retrieval might involve a lot of data...
regards
karl
Best regards
karl
May 16, 2007 at 3:05 pm
Thanks to SQLBill, Ron and Karl for your recommendations.
If I set up a VPN, it would presumably inside the firewall on the SQL Server end and the SQL Server would appear to the client app to be on the same LAN, thus eliminating the need to specifically open up any ports, agreed?
Keith
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply