Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question on certificate and asymmetric logins Expand / Collapse
Author
Message
Posted Wednesday, September 18, 2013 8:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 09, 2013 5:37 PM
Points: 9, Visits: 53
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.
Post #1496199
Posted Thursday, September 19, 2013 5:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:59 PM
Points: 5,970, Visits: 12,873
database mirroring between stand alone servers.
Certs are also used for TDE


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1496337
Posted Thursday, September 19, 2013 8:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 09, 2013 5:37 PM
Points: 9, Visits: 53
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?

Post #1496680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse