Solved

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

Posted on 2011-09-19
4
213 Views
Last Modified: 2012-05-12
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
Comment
Question by:rkneal
4 Comments
 
LVL 25

Accepted Solution

by:
TempDBA earned 84 total points
ID: 36565969
I second the first idea.
0
 
LVL 11

Assisted Solution

by:azarc3
azarc3 earned 83 total points
ID: 36566256
Of the two, #1 is definitely the more secure.
0
 
LVL 14

Assisted Solution

by:binaryevo
binaryevo earned 83 total points
ID: 36569198
I agree with my colleagues, #1 is going to give you the most flexibility and security.
0
 

Author Closing Comment

by:rkneal
ID: 36571070
was hoping for a little backup other than just choosing, but received very detailed explanation from programmer today that made it clear.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now