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

Encrypting traffic between SQL server and a VB .Net app

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.
0
Jeff Certain
Asked:
Jeff Certain
  • 3
  • 2
1 Solution
 
gopinathdeepakCommented:
hi..

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?
0
 
Jeff CertainAuthor Commented:
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?
0
 
gopinathdeepakCommented:
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

;)
0
 
Jeff CertainAuthor Commented:
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.
0
 
gopinathdeepakCommented:
heres another link...which i think u might have come across probably...but check it out if u havent

http://support.microsoft.com/default.aspx?scid=kb;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...

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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