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

Upgrading SQL Server on Windows Server Core

This, thankfully is a quick and easy blog discussing the how’s of an upgrade to SQL Server 2017 from SQL Server 2016 on Server Core. After looking around, seeing product docs with about 2 million pages of info on it, where was the simple upgrade approach? So, my environment is very simple: One SQL Server…

0