Posts Tagged ‘asymmetric keys’

TSQL: Create SQL Logins using certificates and asymmetric keys 70-462

Here’s some TSQL for creating sql logins using certificates and asymmetric keys. Explanatory comments are included. ?View Code TSQLCREATE CERTIFICATE myCert ENCRYPTION BY PASSWORD = ‘Secret2014’ WITH SUBJECT = ‘My certificate for sql logins’;   USE [master] GO   — create sql user with the cert CREATE LOGIN [sql_user_a] FROM CERTIFICATE [myCert]; GO   — […]