Default Endpoint Encryption
-
Comments posted to this topic are about the item Default Endpoint Encryption
-
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:
-
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 -
I learned something new today from the research, so thank you. Learning something is a good way to start the day.
-
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.
-
Nice Question
-
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
-
tom.w.brannon (5/21/2015)
As I read the documentation athttps://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.
-
Iwas Bornready (5/21/2015)
tom.w.brannon (5/21/2015)
As I read the documentation athttps://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.
-
Lovely, isn't it? The deprecated algorithm is the default.
-
RK Mandava (5/21/2015)
MS article: https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspxAh, 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!
-
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 -
Simple and straightforward - thanks, Steve!
-
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 -
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.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply