Establishing a secure logon to sql server 2008 via TADOConnection in Delphi 2010

Posted on 2011-11-01
Last Modified: 2012-05-12
I am logging on to a SQL Server 2008 database on a web site using Delphi's a TADOConnection component.  I want to ensure that the password is not passed in plain text.  What properties do I have to set in the TADOConnection component to protect the login?  Does it support SSL?  
Question by:cerebrumconsulting
    LVL 8

    Accepted Solution

    The article Encrypting Connections to SQL Server, should help you on this. See the link below

    Author Comment

    Thanks, but I've already researched the technet articles.  It seems very complicated.  It talks about installing a certificate.  I have no idea how to get a certificate.  Are you saying that the security has nothing to do with the clientside TADOConnection component?  Would any TADOConnection component connect via SSL automatically if the SQL Server were configured as the technet article specifies?  If so, I'll concentrate on the server side.

    Perhaps I'm working on an erroneous assumption. I thought it was simply a matter of setting some property on the TADOConnection component.  Is that not the case?

    LVL 8

    Assisted Solution

    This article will tell you how to encrypt the connections coming to SQL Server.

    As you are setting up the connection from TADOConnection component to SQL Server, this is the way

    Author Comment

    Thanks.  I thought I had to do something on the client-side as well, via the TADOConnection component, but from what you're saying, I understand that the entire responsibility for encrypting the outgoing password so it cannot be captured by a snooper lies with the server-side of the exchange.

    Author Closing Comment

    There were two original questions:
    What properties do I have to set in the TADOConnection component to protect the login?  and Does it support SSL?

    In providing the original solution, if these had been answered directly--even to say that they didn't apply to the solution--it would have removed all my uncertainty and I wouldn't have had to make a second submission.

    In the second submission, I asked two additional questions to help me clarify my understanding.  I'm assuming that the answer to both is "Yes" based on the second answer from the responder, but that is an assumption, not a certainty, since he/she never answered them directly.

    That is the reason for the grade of "partially".

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    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…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    732 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

    23 Experts available now in Live!

    Get 1:1 Help Now