September 18, 2013 at 8:42 pm
Hello all,
I have a classic question (probably for most of you), as I am new to dba. Why do we use certificate or asymmetric types of login?
As far as I know, Windows and SQL server authenticated logins will do fine jobs. In what scenario does one use certificate or asymmetric logins? I can only see one benefit that you can set specific expiry date for certificate logins, but other than that i can not see anything significant. So based on that, why do we need them?
Please your advise, correct me if I am wrong. Thanks.
September 19, 2013 at 5:55 am
database mirroring between stand alone servers.
Certs are also used for TDE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2013 at 8:34 pm
Thanks Perry.
Can certificate actually be used to connect to Server instance via SQL Management Studio? if yes how? I mean for example, SQL server authenticated login needs to enter their username and password, while Windows authenticated logins do not need to. How about certificate?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply