December 7, 2017 at 8:35 am
We noticed there is a difference in the length of the output from SQL Server 2008 and 2014 versus 2017. When running the following:
select LEN(ENCRYPTBYPASSPHRASE('JohnSmith', '1' ) )
SQL Server 2008/2014 return a 28 character result.
SQL Server 2017 returns a 36 character result.
Anyone know why?
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
December 7, 2017 at 12:53 pm
No idea, but I'll try to track this down.
December 7, 2017 at 1:56 pm
One other note, I get two different encryption values:
2017 - 0x02000000A584538F00817EFA13FB8E176BC435F7FD2A3AEDC9E79AFD2DD203B1356DB2CE
2016 - 0x01000000CBBF1DA4C95CABB66EDE087B7EA983C599D663DB2DA80D49
2017 seems to decrypt 2016, but not vice versa. Need to test more, but this could be an issue.
Nice catch.
December 13, 2017 at 2:10 am
December 14, 2017 at 7:55 am
Thanks immensely, Steve! I sent the information to our development team so they can make the appropriate modifications to our table(s) and code.
I love surprises but *not* "gotchas". LOL
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
December 26, 2017 at 7:22 am
You are welcome and hope things work out. If you're interested, this would make a great short article for you to publish.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy