Community upgrade 10.1->10.2 : Reporting problem

Please confirm you have the correct values for your Reporting DB in your connectionstring.config file located in your web directory on all web nodes & job server.  Once verified, save the plugin again, if it still is red, attempt to recycle your app pool. 

I've corrected the documentation to remove the references to the db roles aspnet_Member_FullAccess & aspnet_Profile_FullAccess.

Please confirm you have the correct values for your Reporting DB in your connectionstring.config file located in your web directory on all web nodes & job server.  Once verified, save the plugin again, if it still is red, attempt to recycle your app pool. 

I've corrected the documentation to remove the references to the db roles aspnet_Member_FullAccess & aspnet_Profile_FullAccess.

Okey, I have added Reporting part into connectionStrings in Web folder (don't see that part in guide) and now can save plugin correctly.

But got new error:

11:39:16 [INFO] BatchStartTask Starting BatchStartTask task
11:39:16 [INFO] BatchStartTask [Starting] Batch Create.
11:39:16 [EROR] BatchStartTask Task BatchStartTask failed after 00:00:00.0919935
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'ControlValues', database 'CommunityReporting', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

I've tried to clarify the documentation a little better.  There are two different sets of accounts that need to be granted permissions when setting up Reporting.  The permissions for the account used in the Web\connectionstrings.config is different from the permissions used by the account in the ETL connectionstrings.config.

The permissions for the account in the Web\connectionstrings.config are specified in the Install Database section of the install community documentation:

Create logins and grant permissions:
It is recommended to use separate accounts for accessing the community database and the reporting database.  If using integrated authentication, create logins for service accounts, otherwise create a new SQL login for the community.  (If using local service accounts, you will have to come back to this step later). 

Grant the community database login the following roles in the community's database:

• aspnet_Membership_FullAccess
• aspnet_Profile_FullAccess
• db_datareader
• db_datawriter
• db_ddladmin

Grant the reporting database login the following roles in the reporting database:

• db_datareader
• db_datawriter
• db_ddladmin

The permissions for the account in the ETL\connectionStrings.config have been corrected and are as follows:

Create login and grant permissions:
The ETL process will read from the community database and write to the reporting database. It is recommended to use a separate login but not required. If using integrated authentication, create a login for the reporting service account, otherwise, create a new SQL login for the reporting. (If using local service accounts, you will have to come back to this step later).
Grant this login the following roles in the community database.

• db_datareader

Grant this login the following roles in the reporting database.

• db_owner

I apologize for any confusion.

Also, to clarify, the due to the differences in permissions, the accounts in the Web\connectionstring.config and the accounts in the ETL\connectionstrings.config should not be the same.

> db_owner
helped, thanks, now it works!

Hi Brian,

We upgraded our Telligent instance too, from 10.1.10 to 10.3.2. I have installed the reporting tool applying those permissions and everything. I'm able to see the Reporting tab under Control Panel, I was able to create and run the task using the Task Scheduler and after finished, there are no errors in the logs, within the ETL folder, or in the Scheduler however, I can't see any data in the Reporting tab, all the values are 0. Any thoughts? Thanks