Configure SQL Server in Management Studio

Procedure

  1. Open SQL Server Management Studio.
  2. In the Object Explorer, right-click the server node you plan to use for PolicyCenter and choose Properties. Typically, the node is the same as computer name.
    The Server Properties dialog opens.
  3. Select the Security page and check SQL Server and Windows Authentication Mode.
    Warning: PolicyCenter does not run if authentication is set to Windows Authentication Mode only.
  4. Select the Memory page.
  5. Adjust the Maximum Server Memory to use at least 200 MB.
  6. With a dedicated host computer running SQL Server, Microsoft recommends that you use the default settings and use SQL Server to manage memory.
    Consult the following Microsoft documentation or an in-depth discussion of memory options.
    Note: Setting the maximum server memory to a specific value can cause performance problems.
  7. Click OK to close the dialog.
  8. Right-click the SQL Server Agent node and select Properties.
  9. Select the General page.
  10. Check Autostart SQL Server if it stops unexpectedly.
  11. Click OK to close the dialog.