This step applies only if the account used as the identity of the new application pool differs from the account that was used for the identity of the default (MSSharePointPortalAppPool) application pool.

You should remove the old account that was used as the identity of the application pool from membership of the db_owner database role on the databases associated with the portal site or sites that the virtual server hosts.

 Note   Do not remove the account from the db_owner database role on the configuration database. If you do, any portal sites that still use the MSSharePointPortalAppPool application pool will no longer be operational.

1. On the computer running SQL Server 2000, open SQL Server Enterprise Manager.
2. In the console tree, expand the Microsoft SQL Servers node.
3. Expand the SQL Server Group node.
4. Expand the node for the SQL Server instance that SharePoint Portal Server uses.
5. Expand the Security node.
6. Click Logins.
7. Right-click the logon name for the old account in the details pane, and then click Properties.
8. In the properties dialog box, click the Database Access tab.
9. In the Specify which databases can be accessed by this login section, clear the Permit check box for each of the following databases:
   • Portal site _SITE database
   • Portal site _SERV database
   • Portal site _PROF database
10. Click OK.
11. Close SQL Server Enterprise Manager.