Pyro
Too busy to comment
- Local time
- Tomorrow, 03:39
- Joined
- Apr 2, 2009
- Messages
- 127
Hi,
I am successfully connecting from MS Access to an Azure SQL database with a connection string that looks like this:
I would love to know how/where other developers are storing connection string variables (e.g. user credentials)?
Some of my considerations so far include environment variables which seem about as secure as plain text. Local encryption, but then users need a key for decryption. I have also messed around with App registration + Azure Key Vault, but you end up at the same point with needing to store variables such as tenant id, client id, client secret etc...
Any thoughts or opinions would be appreciated.
I am successfully connecting from MS Access to an Azure SQL database with a connection string that looks like this:
Code:
strConnection = "Provider=ODBC;" & _
"DRIVER={" & strDriver & "};" & _
"SERVER=" & Azure_Server & ";" & _
"DATABASE=" & SQL_DB & ";" & _
"UID=" & Get_Azure_User & ";" & _
"PWD=" & Get_Azure_PW & ";" & _
"Encrypt=yes;"
I would love to know how/where other developers are storing connection string variables (e.g. user credentials)?
Some of my considerations so far include environment variables which seem about as secure as plain text. Local encryption, but then users need a key for decryption. I have also messed around with App registration + Azure Key Vault, but you end up at the same point with needing to store variables such as tenant id, client id, client secret etc...
Any thoughts or opinions would be appreciated.