sql 2005 "encrypt connection" option
-
On the new server registration dialog box, Connection Properties tab, one finds "Encrypt connection". This strikes me as peculair. What type of encrpytion? 3DES, AES, what bit strength? Certificates? All of these are hidden in this option.
Is encrypting all connections (and the data within them) between LAN clients and sql server 2005 as simple as selecting this check box?
TIA,
Bill
box,
-
By default SQL Server 2005 will generate a 512 bit certificate for this purpose. You will of course need to distribute the certificate to the clients.
You can, however configure it to use your own certificate as below:
-
... By default SQL Server 2005 will generate a 512 bit certificate for this purpose....
Can you point to a reference conferming this ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply