Troubleshooting
General Gathering Task
Remote Powershell network error
Causes:
Unable to establish a connection to remote PowerShell.
Resolution:
Make sure that the Skype for Business server(s) and the machine on which Exchange Reporter Plus is installed are on the same domain. If they are on different domains, make sure a trust has been established between the two.
Make sure that the Skype for Business server(s) and the machine on which Exchange Reporter Plus is installed are on the same subnet.
Make sure that the credentials provided in the Skype Settings page are correct and have sufficient privileges.
Make sure that the machine on which Exchange Reporter Plus is installed is connected to the network.
Logon failed. Invalid username or password.
Resolution:
Username or password given in the Skype Settings page is invalid.
After updating the credentials, go to Data Collection → General → Click Run Now to trigger data collection or wait for the task to run at a scheduled time.
Insufficient privilege for the user.
Resolution:
Add the user 'domainadmin' to CsViewOnlyAdministrator group or CsAdministrator group.
In Exchange Reporter Plus, go to Data Collection → General → Click Run Now to trigger data collection or wait for the task to run at a scheduled time.
SQL Gathering Task
Login failed for user 'username'.
Resolution:
Ensure that:
The user 'username' has SQL server login and the authentication mode is SQL Server and Windows Authentication mode.
The user 'username' has permission to connect to database(s) on SQL Instance(s).
The user's password has not expired, is not a bad password , or requires password change.
The user's account is not locked, expired, or disabled.
SQL Server service is not paused.
Go to Skype for Business → Data Collection → SQL → Click Run Now to start gathering data.
Connection failed for SQL Instance(s)
Resolution:
Ensure that the SQL Browser service is running on the server where SQL Instance(s) is (are) present.
Ensure SQL Server is configured to use TCP/IP.
Ensure connectivity between the machine on which Exchange Reporter Plus is installed and the server on which SQL Instances are present.
Permission denied to access database(s) 'database name' for SQL Instance(s)
Account is disabled for the user 'username' for the SQL Instance(s).
Steps to enable the account:
In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance
Go to Security → Login.
Right click and select Properties.
Select the Status page, and select Enable Under Login.
In Exchange Reporter Plus, go to Skype for Business → Data Collection → SQL → Click Run Now to start gathering data.
Steps to configure permission
In SQL Server Management Studio, open Object Explorer and expand the folder of the SQL server instance on which the database resides.
Go to Security → Login.
Right click the user that have been configured in ERP and select properties.
Go to the User Mapping page, and then select 'LcsCDR' & 'QoEMetrics' databases.
Check the checkbox for db_datareader under database role membership.
Click OK.
In Exchange Reporter Plus, go to Skype for Business → Data Collection → SQL → Click Run Now to start gathering data.
Steps to create SQL Server login
In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance where the new login must be created.
Right-click the Security folder, point to New, and then click Login.
On the General page, select SQL Server Authentication and enter credentials for the user that have configured in ERP.
Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
Go to the Server Roles page and check the Public check box in the Server roles list.
Go to the User Mapping page, and then select 'LcsCDR' & 'QoEMetrics' databases.
Check the checkbox for db_datareader under database role membership.
Click OK.
In Exchange Reporter Plus, go to Skype for Business → Data Collection → SQL → Click Run Now to start gathering data.
ADManager Plus
ADAudit Plus
ADSelfService Plus
M365 Manager Plus
