Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am so confused with this issue, I have application and it has a sql database .

Now, I want this application to access the sql server from anywhere , because there are many clients sharing the same database from many regions.

I don't want to make my current sql server available online by opening ports and allowing TCP remote connections, I am looking for a hosting service or solution that provides sql server database hosting. I just found web hosting services, and they do not allow users to use thier sql databases remotely for storage purposes.

Another words, I want to access it anywhere by some IP or domain or shared server, not by letting my computer working 24 hours to serve clients connections.


share|improve this question

closed as unclear what you're asking by ypercubeᵀᴹ, Paul White, Phil, Mark Storey-Smith, Max Vernon Jun 19 '14 at 17:30

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 1 down vote accepted

Your requirement of having a database accessible from many remote locations is not uncommon.

If I were to do this, I would build a Windows Communication Framework (WCF) service that provides access to the database indirectly. The WCF Service typically resides on a web server, where it operates as a proxy for the SQL Server. The WCF service could provide security for the database by various authentication mechanisms; that is beyond the scope of this answer.

For information on WCF, check these documents:

share|improve this answer

It sounds like cloud offerings fit the bill for your desired requirements. I would recommend that you take a look at Microsoft Azure and what it can do for your. Here are a few resources to get started with:

SQL Database Provisioning a SQL Server Virtual Machine on Azure

Those above options are two different things. The first (SQL Database) is a service that renders a SQL database for you, while the second (Azure VM with SQL Server installed) is just that: A virtual machine that has the SQL Server product installed.

Here is a good reference on the differences between those two, which can help in making a decision and understanding the underlying specifics of each.

Disclaimer: I work for Microsoft

share|improve this answer
Thanks man, but as I read today, Windows Azure sql database has many limitations .. for example : No backup and restore, No mirroring ... I think it's important things. – AymAn AbuOmar Jun 19 '14 at 12:29
@AymAnAbuOmar I'm pretty sure you can backup and restore a database in Azure...where did you read that this was not possible? – Mark Sinkinson Jun 19 '14 at 12:40
Look at this : – AymAn AbuOmar Jun 19 '14 at 17:11

Not the answer you're looking for? Browse other questions tagged or ask your own question.