One of the most useful features in Microsoft System Center Operations Manager is its reporting engine. Installing it can get a little tricky, though. Here's a step-by-step guide.

Learn how to use different tools and techniques to diagnose and resolve common SQL Server problems on Windows, such as connectivity, performance, and security issues.

I can use SQL Server Configuration Manager to have a look – all green arrows, great. I can also connect using SQLCMD and run a few queries. So I launch SQL Server Management Studio and…oh no!