How to access a database through a vpn connection

Forum|Forum|16 years ago
September 15, 2009
2 replies
1756 views

Our production server is housed at an ISP and runs our system. We are using CF8. We have another server in another facility which has the database, SQL Server 2005, and have a VPN connection between the two sites. The server in the remote site is a stand alone and not part of any domain. My question is this; What is the best way to access the database from the production server system?

Thanks in advance.

Dave

Database access

This topic has been closed for replies.

A

Adam Cameron.

Inspiring

"Via its IP address" seems too obvious an answer here, so I'm guessing I'm missing something.

I cringed at the potential performance implications of having the CF and DB servers housed at different sites, and the connection between the two being via VPN, btw. Have you tested how well that performs, before committing to it?

--

Adam

D

dboilerAuthor

Participating Frequently

Hi Adam and thanks for the reply.

I can certainly ping the IP address of the remote database machine but I don't know how to go about writing a script to access the database there.

We have a dedicated T1 line with a permanent tunnel between the two servers. The traffic will be minimal as there will only be few records stored and retrieved at a time.

Thanks and I look forward to hearing from you if you have suggestions on storing and retrieving the data using CF.

Dave

A

Adam Cameron.

Inspiring

I can certainly ping the IP address of the remote database machine but I don't know how to go about writing a script to access the database there.

OK. So just set up a datasource like you normally would then. CF doesn't give a sh!t that the DB is across a VPN, all it cares about is having a TCP/IP connection.

Have you tried to set up a DSN?

--

Adam

ilssac

Inspiring

I don't know if this works for your situation.

But I access my remote SQL Server database through ColdFusion by putting SQLxx.domain.com into the 'Server' paramter of the DSN configuration form.

I do something similar to setup my SQL manager to connect to this database so that I can manage it's objects.

HTH

Ian

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded