Solved

Publishing SQL data for connection from another SQL application

Posted on 2013-12-16
1
228 Views
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?
0
Comment
Question by:Milkybar-kid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 4

Accepted Solution

by:
ItWorked earned 500 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
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

751 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