I have an intranet site that is hosted locally using IIS7.5 on a windows 7 machine. This machine also has a Microsoft SQL server express. Four or five computers on the local network access the data in SQL Server Express.
We are currently in the process of building a word press site that will be hosted on the internet. We need the ability to Access/update some of the data on the word press site with the local data on in SQL Server Express. We do not want to place the SQL database on the web for security reasons.
What are your suggestions for having the word press site communicate with the local SQL Server data?