SQL to SQL Communication RRS feed

  • Question

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


    Andrew Harris Department of Defense
    Thursday, December 30, 2010 10:34 PM