Read this msdn article and doesn't seem to say if it keeps using the same self-signed cert after one is automatically generated.

If SQL Server generates a new SSL cert upon every connection (anyone confirm this?) or every time someone logs in, then does this cause any noticeable performance issue?

1 Answer 1


The self-signed certificate is NOT generated upon every connection/login. So no performance hit here.

Source: http://technet.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx

  • I don't see where it says that in the article. Can you quote it?
    – user35358
    Mar 10, 2014 at 15:11
  • "If a trusted certificate is not installed, SQL Server will generate a self-signed certificate when the instance is started, and use the self-signed certificate to encrypt the credentials."
    – Jens W.
    Mar 10, 2014 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.