Sounds like you have encrypted connections enabled, but haven't set up certificates for those connections. How do you resolve it after the reboot currently?

Not one I've personally hit, but it looks like it's likely to be a permissions issue based on this article from Microsoft.

It is...

First time I've hit. Just a little test, since I'm only running on a local machine with a container for a database, turning off Encrypt and you don't need the...

Latency?

I mean, if we assume everything else being equal, latency. Otherwise, it was something else, good, or bad, at one of the locations. Nothing else makes sense.

I have a magic phrase I've memorized and you can have it too.

"I don't know, but here's how I'd find the answer..."

Now, you have to have a plan...

Since you're talking non-production environments, I'd suggest doing side-by-side installs so you can be more assured of your results. Upgrading, and downgrading, are always fraught with potential issues. You just...

Since you're talking non-production environments, I'd suggest doing side-by-side installs so you can be more assured of your results. Upgrading, and downgrading, are always fraught with potential issues. You just...

Thanks for the feedback all. No, no hate on Trace. I was dead serious in what I said about never questioning anyone using it ever again. Also, equally serious about...

And I understand it's fixed now.

Next time, please, a link. I tracked it down. Seems to be missing or something. I've sent it on to those who might know.

SQL Server 2022 Forum on SQLServerCentral

All set. I tested to make sure posts can go up, so you should be ready to go. Ask away!!

Good point. I'll see what I can do.

Make sure you turn on blocked process report in Extended Events. It'll be a lot easier to KNOW what's going on rather than relying on some random people on...