You must make the account that is used as the identity of the application pool a member of the db_owner database role on the configuration database and on the databases associated with the portal site or sites that the virtual server hosts.

1. On the computer running Microsoft 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, and then do one of the following:
   • If the logon name for the account that you specified as the identity for the application pool does not exist, right-click Logins, click New Login, and then in the Name box, type the account for the user in the format DOMAIN\user_name.
   • If the logon name for the account that you specified as the identity for the application pool already exists, right-click the logon name in the details pane, and then click Properties.
7. In the properties dialog box, click the Database Access tab.
8. For the portal site _SITE database, _SERV database, _PROF database, and for the configuration database (by default, this is SPS01_Config_db), do the following:
   1. In the Specify which databases can be accessed by this login section, select the Permit check box for the database.
   2. In the Database roles for database_name section, select the db_owner check box.
9. Click OK.
10. Close SQL Server Enterprise Manager.