Microsoft has released a Microsoft security advisory about this issue for IT professionals. The security advisory contains additional security-related information. To view the security advisory, visit the following Microsoft Web site:
The Windows Service Isolation feature that is described in this advisory does not correct a security vulnerability. Instead, it is a defense-in-depth feature that may be useful for some customers. For example, service isolation enables access to specific objects without the need to run a high-privilege account or weaken the security protection of the object. By using an access control entry that contains a service SID, a SQL Server service can restrict access to its resources.
To manually configure the Worker Process Identity (WPI) for application pools in IIS, follow these steps. For IIS 6.0
For IIS 7.0 and later versions
- In IIS Manager, expand the local computer, expand Application Pools, right-click the application pool, and then select Properties.
- Click the Identity tab, and then click Configurable. In the User name and Password text boxes, type the user name and password of the account under which you want the worker process to operate.
- Add the selected user account to the IIS_WPG group.
- At an elevated command prompt, open the following folder:
For more information about how to run a command with elevated privileges, visit the following Microsoft Web page:
Type the APPCMD.exe commands, and press ENTER after each command:
appcmd set config /section:applicationPools /Note You must adjust the syntax in the commands, depending on the following:
- string is the name of the application pool
- userName is the user name of the account that is assigned to the application pool
- password is the password for the account