Adding User Accounts in SQL Server Enterprise Manager

Both the Internet Information Server Anonymous user (IUSR_<computername>) and the Exchange Server service account need to be given specific access to the FmLib database. The anonymous access is used when making requests through RDS, and the other is used when the Event Service launches the server-side component.

To add user accounts with SQL Server Enterprise Manager

  1. Run the SQL Server Enterprise Manager. Do this by clicking the Windows Start button and clicking Programs. Then, point to Microsoft SQL Server 7.0 and then click Enterprise Manager. Connect to the server where the FmLib database has been deployed.
  2. Open the Security node, and right-click on the Logins subnode. (Alternatively, you can select the Logins subnode, and click the Action button on the MMC toolbar.) Select New Login from the context menu. The SQL Server Login Properties dialog box will appear.
  3. On the General tab, type the fully qualified domain name (DOMAIN\USERNAME) of the IIS Anonymous user in the Name text box. When you type the backslash, the domain name will appear in the Domain text box. Ensure the Grant access option button is selected. Optionally, change the default database to FmLib for this login.
  4. Click the Database Access tab. Select the FmLib database by clicking the check box in the Permit column. Assign a database role appropriate for the user access; the IIS Anonymous user account should be assigned to the db_datareader role, whereas the Exchange Server service account should be assigned to the db_datawriter role. Note: all logins must belong to the "public" database role, so this role cannot be unselected.
  5. Click OK to close the dialog box and create the new SQL Server login.

Note  If any of the SQL Server login accounts exist, you should verify that sufficient privileges have been assigned. See step 4, above.