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?