• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Advice on Design of Agent Program to get/put SQL data

we are developing an agent that will reside on endpoints (computers) and they will have to talk through a firewall to a SQL server.  The problem is we want to make this as secure as possible, and have doubts that direct connections to SQL is the way to go.  Trying to get some opinions on best method to do this. Here is what we are considering.

1.  A web service located on same box as SQL server, the agents talk to the web service instead of SQL directly.  Would use IIS and SSL

2. A socket windows service that listens on port xxx on server, the agents talk to this service, the service communicates to SQL and returns results.

Our programmers are thinking 1 is the best and most secure way, but wanted to get some others thoughts and ideas
0
rkneal
Asked:
rkneal
3 Solutions
 
TempDBACommented:
I second the first idea.
0
 
Kelvin McDanielSr. Developer/ConsultantCommented:
Of the two, #1 is definitely the more secure.
0
 
binaryevoCommented:
I agree with my colleagues, #1 is going to give you the most flexibility and security.
0
 
rknealAuthor Commented:
was hoping for a little backup other than just choosing, but received very detailed explanation from programmer today that made it clear.
0
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now