Publishing SQL data for connection from another SQL application

Posted on 2013-12-16
Medium Priority
Last Modified: 2016-02-26
This is a newbie question so please be assume my knowledge is very basic. I have a SQL database that is the backend to a web application running on SQL2008 Web edition. I want to allow access to some of the data to an external application without allowing direct connections to the database so the data should be available over the web. It does not need to be human readable just picked up from another web application so XML would possibly be a suitable format. I have been researching that a web service using SOAP may be suitable but I have then found a TechNet article referring to Authentication over SOAP being deprecated.
What is the best way to allow external authenticated access to SQL data over the web?
Question by:Milkybar-kid
1 Comment

Accepted Solution

Hiran Desai earned 2000 total points
ID: 39723353
Depends upon requirement you have.

Yes you can use SOAP for allowing users to access your DB data.... and yes you said, Web Services using SOAP are getting deprecated.

Another way you can have WCF service (over HTTP binding) using XML or JSON.

I guess you don't want to allow access to your sever from SQL else you can have linked Server as well where you can define role and give access but that won't be useful for your web application

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question