I currently have a site that is hosted through a host site(Inmotion Hosting). I have created a few mySQL databases on it and use php to query it. I would like to do the same thing but connect/query my Microsoft SQL Database on my local network. Is there a way to do this? If so what is the best way to set it up?
I am currently using MS SQL Server 2008 R2 (Will be upgrading soon)