Encrypting traffic between SQL server and a VB .Net app

Posted on 2005-05-16
Last Modified: 2008-01-09
Is it possible to encrypt traffic between a SQL server and a VB .Net app using the SQLClient objects?
If so,
a) how?
b) what methods of encryption are possible?

Thank you.
Question by:Jeff Certain
    LVL 4

    Expert Comment


    i have never used it, but i see a Force Protocol Encryption checkbox in the sqlserver network utility tool window (SVRNETCN.EXE)...

    i believe that should take care of it.

    wanna try?
    LVL 24

    Author Comment

    by:Jeff Certain
    I'm not familiar with the network utility tool -- where would I find this?

    Any idea what the performance hit for encrypting traffic is like?
    LVL 4

    Accepted Solution

    like i said, i dont have much idea about this...i didnt find anything on the SqlClient Class...

    but this utility is an exe file (SVRNETCN.EXE) ...and the location is the Program Files\Microsoft SQL Server\80\Tools\Binn..

    but i think the PATH is already set to this folder and the command should be globally available...

    just go to command prompt and run SVRNETCN.EXE..

    the option is there but i dont know what it does..

    from what i read, i forces all the clients connected to the server to conform to the encryption protocol..

    sorry...i know i havent been of much help..

    good luck though

    LVL 24

    Author Comment

    by:Jeff Certain
    Well... right now I only have a production server up and running... I might just wait until I get a test server running before I enable that one! Thanks for the help.
    LVL 4

    Expert Comment

    heres another link...which i think u might have come across probably...but check it out if u havent;en-us;316898&sd=tech

    theres another utility that allows client network configuration...starting with CLI.. (CLI*.EXE)...dont remember the name...check it out too...


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Article by: jpaulino
    XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String ( Literal, only instead of starting and ending with w…
    1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now