When SQL has no certificate…

Yesterday I posted a blog on how to identify the SQL Certificate used. I had some questions come from this, and the biggest one was, but what if the registry key is blank? Fear no more, here are steps to populate this registry key properly. I was able to reproduce this issue on a system…

0

PS without BS: Finding the SQL Cert and trusting it to a remote system

This was an interesting case, and surprisingly didn’t really find anything on how to do this out there. But, the problem statement was simple. When trying to connect to SQL (this was PowerBI, but was the same for SSMS), this error showed up: A connection was successfully established with the server, but then an error…

0

Demystify PKI – Act II: Certificate Logging

This is a quick blog on how to enable certificate logging, as by default this is not enabled in Windows. For reference, this is a multi-part blog on PKI, here are the other entries: Demystify PKI (aka AD Certificate Services) – Act I: Cryptography First, a common falacy is that all things are located in…

0

Demystify PKI (aka AD Certificate Services) – Act I: Cryptography

Some things are just a lot to digest, and so I thought it may be useful to the ditial world to kind of break down and demystify some of the key concepts. This is part of a multi-part blog, as it’s a lot to write at once. The intent here isn’t to write a comprehensive…

0

Troubleshooting Internet Explorer and the CRL mystery

This was an interesting case, and didn’t see much on this when I searched around the public internet, so want to leave a little something in case it helped someone else. The Problem Statement Users on Windows 7 and Internet Explorer 11 or Microsoft Edge on Windows 10 were experiencing no issues going to a…

1