By tapscolam on

I was wondering if it is possible to access a sql server database sitting on a local server network. Drupal will be on a remote hosting server. Is this something that can be done and if yes may you please point me towards the right direction. The idea is to link drupal to a database system that is running on a local area network, drupal need to be on remote hosting and the sql database is on local area network. Any ideas???

⋅ Categories: Drupal 7.x

Comments

dudycz’s picture

dudycz commented

If it's Drupal's primary database then I think it's terrible idea.
Unless you have heavily cached site serving content for anonymous users your visitors will have to wait very long time for page to load because of network latency. When Drupal serves dynamic personalised content it can often perform hundreds database queries to render single page.

tapscolam’s picture

tapscolam commented

Thank you for that. Basically it won't be the primary database but there are some few queries to fetch data from the secondary database. I never thought about network latency though.

bitradiator’s picture

bitradiator commented

Here'a a docs page on how to go about it. If your "local server network" has a static IP address you shouldn't have any issues.