Learn how to use SQL Server Configuration Manager to configure authentication modes, service accounts, encryption options, and firewall rules for your SQL Server instance.

When configuring the SQL Server for remote access, you must allow certain ports and programs through the firewall to ensure clients can connect to the database securely. Before we begin, make sure you ...

Close SQL Server Configuration Manager. For more information about enabling protocols for the SQL Server Database Engine, see Enable or Disable a Server Network Protocol.

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.

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!