SQL Server Configuration Manager is a tool that allows you to manage the security settings of your SQL Server instances, services, and network protocols.

By default, the SQL Server Agent service account is mapped to the default SQL Server Agent service SID (NT SERVICE\SQLSERVERAGENT), which is a member of the sysadmin fixed server role.The account must ...

Create Remote SQL Configuration Manager MMC. From the management server (here m-sqla1) I create all “SQL Configuration Manager” consoles for all server (core or not) I have to managed. From M-SQLA1, ...

I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2. This feature, known as Extended Protection for Authentication (Extended ...