Is it possible to have SQL use certs for 2 way SSL/TLS communication in SQL to SQL communication? We currently do not have our SQL servers as part of a Domain (for security purposes).
Currently, we use username/password to do the SQL to SQL communication which has been dreadful since this implementation requires us to change passwords every month and becomes a burden on actually having successful data roll-up. By leveraging certs/PKI,
this would drastically reduce our down-time as well as make it significantly more cheapier to implement SQL to SQL communication in a secure manner.
Thanks!
Andrew Harris Department of Defense