So the credential that was created (is Step 4) is associatedwith the
TDE_Login (in Step 9). It is the credential that SQL uses to contact
AKV. Via the Azure Active Directory Application (from Part 2) This whole
process is confusing and complicated. (Written years ago - way before my
time). I've trie...
Adrian: Thanks so much for your reply. I understand TDE_Login is tied to
credential linked to Asymmetric key, but TDE_Login is used by what to
contact AKV? by application? I read your posting multiple times, seems
that once the database TDE is turned on, there is nothing to config,
right? there is n...
Hello EricHe2020; Sorry for the delay in getting back to you, I've been
out on leave for a few months. You are correct, this is not a login used
for logging in to the server by a user. It is a login for the credential
that is tied to an ASYMMETRIC Key. That is then used to contact AKV.
This is a lot...
What if you need conditional parameters like textbox(id="txtName",
Prompt="Filter by Name") strSQL = "SELECT * FROM tblNames "if txtName <>
"" Thenparam = txtNamestrSQL &= "WHERE Name LIKE ?"end if ds =
sqlsrv_query(conn, strSQL , param)(don't mind the syntax)Would that
work?
Andrian; Thx for the excellent post. can I ask what is purpose of this ?
this login is not for users to login? --Create a Login that will
associate the asymmetric key to this loginCREATE LOGIN TDE_LoginFROM
ASYMMETRIC KEY EKMSampleASYKey;
Latest Comments