Configure a Server to Run the Off By Default Policy

In Object Explorer, right-click your instance of SQL Server, point to Policies, and then click Evaluate.

In the Evaluate Policies dialog box you can select policies from another instance of SQL Server or from a file. For this step, leave Source set to your instance of the Database Engine.

In the Policies section, select the Off By Default policy.

To see whether the server is in compliance with the policy, click Evaluate.

In the Results area, you will see a green circle with a check mark if the Database Engine complies with the policy. You will see a red circle with an X if the Database Engine does not comply with the policy.

In the Target Details area, you will see additional information in Message if an error occurs. Click View to see a report of that contains the results of the check for each facet property that was checked.

The policy description is displayed at the bottom of the page, and the Additional help section displays the hyperlink that you have configured for the policy. Click the message hyperlink to open the Web page that you specified when you created the policy.

Close the browser, and then close the Results Detailed View dialog box.

If the server is out of compliance and you want to disable both Database Mail and SQL Mail, click Apply in the Evaluation Results page.

Close both the Results Detailed View and the Evaluate Policies dialog boxes.