Default Endpoint Encryption

Question

Default Endpoint Encryption

Steve Jones - SSC Editor

SSC Guru

Points: 736479
More actions
May 20, 2015 at 10:09 pm

#300800

Comments posted to this topic are about the item Default Endpoint Encryption

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 1

Nice question! I didn't have access to a server to test the code, so had to guess based on documentation. I saw nothing about the default algorithm, so I went with AES. Doh!

Learned something new, but it seems the documentation is a bit lacking. Shocking, since MS documentation is always perfect... :hehe:

Hany Helmy SSChampion Points: 13921 More actions · Answer 2

I was about to go with the very common & recommended Algorithm type. good that I tested it before hitting submit 😎

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I learned something new today from the research, so thank you. Learning something is a good way to start the day.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 4

As I read the documentation at

https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspx

and saw

ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED }

[ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ]

I would expect that encryption is disabled and therefore there is none. Since that was not an option, I picked RC4 and got lucky. I don't deal with this aspect of my instances.

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 5

RK Mandava

SSCarpal Tunnel

Points: 4153

May 21, 2015 at 6:57 am

#1799641

Nice Question

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 6

Jacob Wilkins (5/20/2015)
Nice question! I didn't have access to a server to test the code, so had to guess based on documentation. I saw nothing about the default algorithm, so I went with AES. Doh!
Learned something new, but it seems the documentation is a bit lacking. Shocking, since MS documentation is always perfect... :hehe:

MS article: https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspx

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

tom.w.brannon (5/21/2015)
As I read the documentation at
https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspx
and saw
ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED }
[ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ]
I would expect that encryption is disabled and therefore there is none. Since that was not an option, I picked RC4 and got lucky. I don't deal with this aspect of my instances.

I looked at the same article. It does mention that RC4 is the default. But it also says that it is deprecated.

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 8

Iwas Bornready (5/21/2015)
tom.w.brannon (5/21/2015)
As I read the documentation at
https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspx
and saw
ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED }
[ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ]
I would expect that encryption is disabled and therefore there is none. Since that was not an option, I picked RC4 and got lucky. I don't deal with this aspect of my instances.
I looked at the same article. It does mention that RC4 is the default. But it also says that it is deprecated.

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 9

Lovely, isn't it? The deprecated algorithm is the default.

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 10

RK Mandava (5/21/2015)
MS article: https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspx

Ah, good point! I actually just looked quickly at what turned out to be the same article referenced in the answer, which I don't think mentions that RC4 is the default (although I could be wrong about that too; I still haven't had any coffee this morning!)

At any rate, that serves me right for trying to hastily answer a question before going to bed :blush:

Cheers!

webrunner SSC-Dedicated Points: 31885 More actions · Answer 11

Thanks, I didn't know that.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Revenant SSC-Forever Points: 42467 More actions · Answer 12

Revenant

SSC-Forever

Points: 42467

May 21, 2015 at 8:55 am

#1799719

Simple and straightforward - thanks, Steve!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Steve Jones - SSC Editor (5/21/2015)
Lovely, isn't it? The deprecated algorithm is the default.

You're not surprised are you?:cool:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 14

SQLRNNR (5/21/2015)
Steve Jones - SSC Editor (5/21/2015)
Lovely, isn't it? The deprecated algorithm is the default.
You're not surprised are you?:cool:

I wish I could say yes, but that would be disingenuous.