vendredi 6 novembre 2015

How to connect to Microsoft SQL Server database instance via Internet with PHP?

I am new to Microsoft SQL Server and am not sure how to connect via internet with PHP to retrieve some data from a table in a database instance in MS SQL Server in the server.

The main server is connected via hamachi with a few other outlets that will periodically update some data to the main server database

the "Server" is actually a desktop computer running on win 8 that is on 24/7

I got the server hostname ( which is the pc name/something ) and created a login account + password with Microsoft SQL Server Management Studio that can access the database I want locally.

Bu I have no idea how the http:// url looks like or how to connect to the DB via internet with PHP ...

or is it possible to connect with just the IP?

Do I need to do Port Forwarding + install PHP, apache, SQL FTP etc and setup the server?

Aucun commentaire:

Enregistrer un commentaire