I've got a desktop application connecting to SQL Server directly, I see a lot of posts saying you shouldn't expose SQL Server directly to the internet but none say why. Some background:
- Scalability, load balancing and other performance criteria are not an issue for my scenario
- My app needs to work locally (with local SQL Server) or on with a remote repository so that multiple users can share data (hosted SQL Server, which is my question)
I noticed connecting to SQL Azure looks like it's very much like a standard remote SQL Server (http://www.windowsazure.com/en-us/develop/net/how-to-guides/sql-database/#using-sql-server)
I understand that opening any ports is an inherit vulnerability but that can't be the only reason. I must be missing something but I'm not sure what?
What's a real alternative other than deploying the lower half of my application as a web service?