Solved

How to connect a SQL server with the website.

Posted on 2012-04-10
11
475 Views
Last Modified: 2012-06-22
Hello:

I have a SQL server database that is now serving the data for a website.
Actually, this database is currently on a remote SQL server and the communication between the Website and the database is done with via that remote SQL server.

I have to change that configuration in that the Website will communicate with a new SQL server LOCALLY in our building. The DBA from the remote location sent over a full backup of the DB and I have restored it on the New server that needs to be the production server soon.
The website is built on Wordpress.

How do I make the connection between the Website and the SQL server?
How do I make them speak to one another?

Thank you.
0
Comment
Question by:noamco36
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
11 Comments
 
LVL 5

Assisted Solution

by:rtay
rtay earned 84 total points
ID: 37829153
Are you hosting the website locally as well?
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 416 total points
ID: 37829324
You need a web server that is running PHP.  Is the original web site using MySQL or Microsoft SQL Server?  And is it on IIS or Apache?
0
 

Author Comment

by:noamco36
ID: 37829327
no, the website is hosted with ipage.com
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:noamco36
ID: 37829357
and will continue to be hosted by ipage.com after we switch to the new LOCAL SQL server.
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 416 total points
ID: 37829362
Hosting it Outside and using any SQL server Inside may be a problem.  You have to configure the firewalls and access permissions in ways that a normal Wordpress site doesn't need to do.  Why are you splitting the web hosting and the SQL hosting?
0
 

Author Comment

by:noamco36
ID: 37829388
The site is actually using PHP/MySQL.  It is actually just  a WordPress modified/customized site (does that make any difference?),   but the site its getting data from a remote SQL server.

This is the configuration the company chose.
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 416 total points
ID: 37829402
The way that Wordpress works is that it gets all of it's content from the database which means that it makes multiple queries for every single page load.  Typically in a hosting environment, the SQL server is either on the same machine or on the local network with 100Mbps or 1Gbps access.  Unless you have that kind of access to your LOCAL SQL server from the hosting site, your Wordpress site is going to Slow Down a very great deal.
0
 

Author Comment

by:noamco36
ID: 37829549
I am fine with the connection speed. how do you MAKE the connection between them?

(thats the way it is now with the remote SQL server.)
I just have to move the database to a new SQL server and make sure its feeding the website.
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 416 total points
ID: 37829724
Set up a MySQL server and import the databases and set up the users that the Wordpress site requires.  Then just change the hostname in the Wordpress config files.  You do have to open your firewall to port 3306 for external access to the MySQL server.
0
 

Author Comment

by:noamco36
ID: 37829744
you mean, to change from using SQL server to MySQL in general for the website?
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 416 total points
ID: 37829756
I mean that Wordpress was not designed to use Microsoft SQL Server at all.  If someone else already made it work for you, then Ok.  Otherwise, please read this page: http://wordpress.org/support/topic/how-to-integrate-wordpress-with-ms-sql-server-database

And MySQL and Microsoft SQL Server can exist on the same machine just fine if that's what you need.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses how to create an extensible mechanism for linked drop downs.
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question