Decryptbypassphrase nvarchar

Ask Question. Asked 2 years, 4 months ago. Active 2 years, 4 months ago. Viewed 2k times. The result of my tests were these: According to this Microsoft fix , [ Improve this question. Ronaldo Ronaldo 3, 1 1 gold badge 7 7 silver badges 37 37 bronze badges. Add a comment. Active Oldest Votes. Yes, right on point. Improve this answer. Function source code if you want to compile and deploy the project yourself:.

Well guys, I hope you enjoyed this very technical and complicated post.. Click on the banner to learn about and purchase my database training on Azure. Views: 4. SqlTypes; using System. Linq; using System. Cryptography; using System. Core, System. Data e System. Create ; cryptoAlgo. PKCS7; cryptoAlgo. CBC; hashAlgo. TransformFinalBlock passwordBytes, 0, passwordBytes. Length ; cryptoAlgo. Take keySize. TransformFinalBlock encrypted, 0, encrypted.

ToUInt32 decrypted, 0 ; if magic! Skip 8. IndexOf decryptedData, byte 0! GetString decryptedData : Encoding. Range 0, hex. And so the below error "Msg , Level 16, State 5, Line 1 String or binary data would be truncated. But the link clerly states cleartext A variable of type nvarchar , char , varchar , binary , varbinary , or nchar containing the cleartext. I would think nchar might work since each nchar is 2 bytes, then nchar is bytes.

Do you have an example that demonstrates the problem? It's easier to investigate, if there is a case to work from. To be able to test, I need a full repro script that creates and opens you key. Hi Erland.. Hi Sathyanarrayanan Why does nchar 14 works? The encrypted string may be longer than the source. Now, some will argue that you should always store your passwords as strongly encrypted text that will never need to be decrypted, and in most cases I would agree with that.

However, I have run across situations where being able to decrypt the password is necessary. Notice that it specifies a pass phrase , not pass word. The advantage of using a passphrase is that it is easier to remember a meaningful phrase or sentence than to remember a comparably long string of characters.

By doing this, you can generate a much more secure password sentence or phrase instead of a single word. That is the passphrase we will use. Try it:.

The first thing we need to do is determine the size of our encrypted password column. The size of the returned value is going to depend on the size of the actual password being encrypted.