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?


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 '14 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 '14 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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