[update] It's worth mentioning that this post only applies to standard and higher licenses of Community Server. [/update]

Here’s another common question over on the Community Server forums that site admins might not know how to do as it isn’t “officially” documented anywhere:  “I’ve purchased a licensed version of CS that includes blog and user reporting, but they aren’t enabled by default.  How do I enable them?”  It’s actually a fairly simple process of editing your web.config file and setting up two jobs on your SQL Server database (if you are hosted somewhere, you'll need to ask your hoster to do this for you).  The solution is:

1. Open your CS web.config file.
   
2. Add the following to <httpModules>:  <add name="CSVisitors" type="CommunityServer.VisitorCountHttpModule, CommunityServer.Components" />
3. Create a SQL Job that runs every morning at 1:00 AM with the command exec cs_BlogActivityNightlyJob
4. Create a SQL Job that runs every morning at 1:30 AM with the command exec cs_UserActivityNightlyJob

If you're not familiar with creating jobs from either Enterprise Manager/SQL Server Management Studio, please consult the following links accordingly:

• SSMS
• Enterprise Manager

You can then view your reports at <root>/controlpanel/Setup.aspx under the Reports section.

---

Posted Thu, Jun 15 2006 11:46 PM by Jayson Knight