Question on certificate and asymmetric logins

  • 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.

  • database mirroring between stand alone servers.

    Certs are also used for TDE

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • 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