In [!INCLUDE ssNoVersion] Configuration Manager, in the console pane, select SQL Server Services. In the details pane, right-click SQL Server Agent(server_name), where server_name is the name of the [ ...

Use the Startup Parameters tab of the SQL Server Properties dialog box to add or remove startup parameters, which can affect Database Engine performance. Do not enter a separator between parameters. [ ...

SQL Server Configuration Manager is a tool that allows you to manage the security settings of your SQL Server instances, services, and network protocols. In this article, you will learn how to use ...

Windows Insider Best Configuration Manager Queries Readers share their tried-and-true SCCM queries. By Greg Shields 07/01/2008 I often tell inquisitive admins that there's both an art and a ...

8. In the TCP/IP properties in the configuration Manager change “Listen All” to YES 9. In the IP Address TAB change Enabled to “NO” for the IP which had Virtual SQL Server IP Address.

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.