Topic last updated—June 2008

Note
The information in this topic applies only to Configuration Manager 2007 R2.

Before client status reporting can store data in the Configuration Manager 2007 R2 site database, you must configure the appropriate permissions to give the client status reporting service account access to the Microsoft SQL Server database.

Use the following procedure to give the client status reporting service account access rights to the Configuration Manager 2007 site database.

Note
If client status reporting is installed on the computer that hosts the Configuration Manager 2007 site database and the client status reporting service account has administrator permissions to the computer, you do not need to manually configure permissions to the site database.

To configure permissions to the site database

  1. On the Configuration Manager 2007 SQL Server-based computer, open SQL Server Management Studio.

  2. In the Connect to Server dialog box, ensure the correct SQL Server-based computer is specified and then click Connect.

  3. In SQL Server Management studio, navigate to Security / Logins.

  4. Right-click Logins and then click New Login.

  5. In the Login – New dialog box, enter the domain and user account name of the client activity monitoring service account in the Login name field in the form domain\account. You can also click Search to browse for a Windows account.

  6. Under the database server authentication settings, select Windows authentication.

  7. Click OK to close the Login – New dialog box.

  8. In SQL Server Management studio, navigate to Databases / <ConfigMgr database name> / Security / Users

  9. Right-click Users and then click New Users

  10. In the Database User – New dialog box, enter the login name (for example, Client status account) in the User name field.

  11. Select Login name, and enter the domain and user account name of the client activity monitoring service account (in the form domain\user account) or click the Browse button to search for the account

  12. Click OK to close the Database User – New dialog box.

  13. In SQL Server Management studio, navigate to Databases / <ConfigMgr database name> / Security / Roles / Database Roles.

  14. Right-click the database role smsdbrole_CH and then click Properties.

  15. In the Database Role Properties dialog box, click Add to add a user account to this role.

  16. In the Select Database User or Role dialog box, enter the login name you created previously (for example Client status account) and then click OK.

  17. Click OK to close the Database Role Properties dialog box.

See Also