Setting Configuration Options with SQL Enterprise Manager

As mentioned previously, you can set SQL Server configuration options by using SQL Server Enterprise Manager. Simply invoke Enterprise Manager from the Microsoft SQL Server program group and right-click on the Server folder. Figure 40.4 shows the SQL Server Properties (Configure) dialog box and the different tabs available. Don't be misled: Some of these tab options are not configuration options that correspond to sp_configure, such as the Security tab and some functions under the Database tab. However, as you will see, Microsoft has done a nice job of organizing and presenting the option information. You will also see that several of the configuration options cannot be managed from this interface. The ones not addressed are rarely used options, such as the AWE-enabled option.

Figure 40.4. Enterprise Manager and configuration properties.

Remember: You must have sysadmin and serveradmin fixed server roles to make changes.