Solved

Publishing SQL data for connection from another SQL application

Posted on 2013-12-16
1
227 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

763 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