HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Can we configure Certificate-based Authentication to connect(logon) sql client?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
certificatecanconnectlogonsqlauthenticationclientbasedconfigure

Problem

Can we configure Certificate-based Authentication to connect(logon) sql client? or any other method to connect sql client using mutual authentication(sql server and sql client)?

Solution

Answer originally provided in a comment by Kin:

The answer is no.

Only Database Mirroring and Service Broker connections can authenticate using certificates.

You might want to check Remus Rusanu 's answer on Stack Overflow and his article:

How does Certificate based Authentication work?.

Context

StackExchange Database Administrators Q#97809, answer score: 3

Revisions (0)

No revisions yet.