Solved

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

Posted on 2011-09-19
4
217 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 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