I have to connect remotely to my MSSQL database. However, I am a little unsure as to the best way to do this. Can I connect directly to the database from my client machine, or would it be best to create some kind of local script that does the connection and serves XML or JSON to my client?
Also, what what will need to be configured on my database to allow this connection, and on the computer hosting the database? Will I need to set it up as a web-server?