Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Publishing SQL data for connection from another SQL application

Posted on 2013-12-16
1
Medium Priority
?
263 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
1 Comment
 
LVL 4

Accepted Solution

by:
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
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

971 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