Key based encryption and Decryption in SQL Server
0
I am trying to convert a string to base 64 string and I was able to convert them using cast, but I need to use a key for encryption and during decryption the same key must be used. I don't have any idea about it. Have anyone tried it .
SELECT CAST('string' as varbinary(max)) FOR XML PATH(''), BINARY BASE64
For Base64 to string
SELECT CAST( CAST( 'c3RyaW5n' as XML ).value('.','varbinary(max)') AS varchar(max))
sql
sql-server asked 3 hours ago
Srinivasan Rajasekaran
23519
add a comment |
0
I am trying to convert a string to base 64 string and I was able to convert them using cast, but I need to use a key for encryption and during decryption the same key must be used. I don't have any idea about it. Have anyone tried it .
SELECT CAST('string' as varbinary(max)) FOR XML PATH(''), BINARY BASE64
For Base64 to string
SELECT CAST( CAST( 'c3RyaW5n' as XML ).value('.','varbinary(max)') AS varchar(max))
sql
sql-server asked 3 hours ago
Srinivasan Rajasekaran
23519
did you see it ? mssqltips.com/sqlservertip/4903/…
– Md. Zakir Hossain
3 hours ago
Are you aware that Base 64 encoding has nothing to do with encryption? If you need encryption, you need to read up on the various mechanisms built into SQL Server for this and pick one that matches your threat model. Encryption isn't a magic wand and so you do need to have a threat model before you even start thinking about encryption. There's far too much to read and think about to fit on a Q&A site on this.
– Damien_The_Unbeliever
46 mins ago
add a comment |
0
0
0
I am trying to convert a string to base 64 string and I was able to convert them using cast, but I need to use a key for encryption and during decryption the same key must be used. I don't have any idea about it. Have anyone tried it .
SELECT CAST('string' as varbinary(max)) FOR XML PATH(''), BINARY BASE64
For Base64 to string
SELECT CAST( CAST( 'c3RyaW5n' as XML ).value('.','varbinary(max)') AS varchar(max))
sql
sql-server asked 3 hours ago
Srinivasan Rajasekaran
23519
I am trying to convert a string to base 64 string and I was able to convert them using cast, but I need to use a key for encryption and during decryption the same key must be used. I don't have any idea about it. Have anyone tried it .
SELECT CAST('string' as varbinary(max)) FOR XML PATH(''), BINARY BASE64
For Base64 to string
SELECT CAST( CAST( 'c3RyaW5n' as XML ).value('.','varbinary(max)') AS varchar(max))
sql
sql-server sql
sql-server asked 3 hours ago
Srinivasan Rajasekaran
23519
asked 3 hours ago
Srinivasan Rajasekaran
23519
edited 2 hours ago
asked 3 hours ago
Srinivasan Rajasekaran
23519
asked 3 hours ago
Srinivasan Rajasekaran
23519
asked 3 hours ago
Srinivasan Rajasekaran
23519
23519
did you see it ? mssqltips.com/sqlservertip/4903/…
– Md. Zakir Hossain
3 hours ago
Are you aware that Base 64 encoding has nothing to do with encryption? If you need encryption, you need to read up on the various mechanisms built into SQL Server for this and pick one that matches your threat model. Encryption isn't a magic wand and so you do need to have a threat model before you even start thinking about encryption. There's far too much to read and think about to fit on a Q&A site on this.
– Damien_The_Unbeliever
46 mins ago
add a comment |
did you see it ? mssqltips.com/sqlservertip/4903/…
– Md. Zakir Hossain
3 hours ago
Are you aware that Base 64 encoding has nothing to do with encryption? If you need encryption, you need to read up on the various mechanisms built into SQL Server for this and pick one that matches your threat model. Encryption isn't a magic wand and so you do need to have a threat model before you even start thinking about encryption. There's far too much to read and think about to fit on a Q&A site on this.
– Damien_The_Unbeliever
46 mins ago
did you see it ? mssqltips.com/sqlservertip/4903/…
– Md. Zakir Hossain
3 hours ago
did you see it ? mssqltips.com/sqlservertip/4903/…
– Md. Zakir Hossain
3 hours ago
Are you aware that Base 64 encoding has nothing to do with encryption? If you need encryption, you need to read up on the various mechanisms built into SQL Server for this and pick one that matches your threat model. Encryption isn't a magic wand and so you do need to have a threat model before you even start thinking about encryption. There's far too much to read and think about to fit on a Q&A site on this.
– Damien_The_Unbeliever
46 mins ago
Are you aware that Base 64 encoding has nothing to do with encryption? If you need encryption, you need to read up on the various mechanisms built into SQL Server for this and pick one that matches your threat model. Encryption isn't a magic wand and so you do need to have a threat model before you even start thinking about encryption. There's far too much to read and think about to fit on a Q&A site on this.
– Damien_The_Unbeliever
46 mins ago
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53942170%2fkey-based-encryption-and-decryption-in-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53942170%2fkey-based-encryption-and-decryption-in-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
did you see it ? mssqltips.com/sqlservertip/4903/…
– Md. Zakir Hossain
3 hours ago
Are you aware that Base 64 encoding has nothing to do with encryption? If you need encryption, you need to read up on the various mechanisms built into SQL Server for this and pick one that matches your threat model. Encryption isn't a magic wand and so you do need to have a threat model before you even start thinking about encryption. There's far too much to read and think about to fit on a Q&A site on this.
– Damien_The_Unbeliever
46 mins ago