Take the 2-minute tour ×
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. It's 100% free, no registration required.

I am so confused with this issue, I have vb.net 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.

Thanks

share|improve this question

closed as unclear what you're asking by ypercube, Paul White, Phil, Mark Storey-Smith, Max Vernon Jun 19 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.

add comment

2 Answers 2

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:

http://msdn.microsoft.com/en-us/library/ms731082%28v=vs.110%29.aspx

http://www.codeproject.com/Articles/42643/Creating-and-Consuming-Your-First-WCF-Service

http://code.msdn.microsoft.com/Create-a-WCF-Service-c3486993

share|improve this answer
add comment

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 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 at 12:40
    
Look at this : msdn.microsoft.com/library/azure/ff394115.aspx –  AymAn AbuOmar Jun 19 at 17:11
add comment

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