✖

- Related Products
- ADManager Plus

  Active Directory Management & Reporting

  Download | Demo
- ADAudit Plus

  Real-time Active Directory Auditing and UBA

  Download | Demo
- ADSelfService Plus

  Self-Service Password Management

  Download | Demo
- EventLog Analyzer

  Real-time Log Analysis & Reporting

  Download | Demo
- AD360

  Integrated Identity & Access Management

  Download | Demo
- Log360

  Comprehensive SIEM and UEBA

  Download | Demo

# 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)

> Resolution:

> - Ensure that the user has permission to access the mentioned database(s).

Account is disabled for the user 'username' for the SQL Instance(s).

> Steps to enable the account:

> 1. In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance

> 2. Go to Security → Login.

> 3. Right click and select Properties.

> 4. Select the Status page, and select Enable Under Login.

> 5. In Exchange Reporter Plus, go to Skype for Business → Data Collection → SQL → Click Run Now to start gathering data.

Steps to configure permission

1. In SQL Server Management Studio, open Object Explorer and expand the folder of the SQL server instance on which the database resides.

2. Go to Security → Login.

3. Right click the user that have been configured in ERP and select properties.

4. Go to the User Mapping page, and then select 'LcsCDR' & 'QoEMetrics' databases.

5. Check the checkbox for db_datareader under database role membership.

6. Click OK.

7. 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

1. In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance where the new login must be created.

2. Right-click the Security folder, point to New, and then click Login.

3. On the General page, select SQL Server Authentication and enter credentials for the user that have configured in ERP.

4. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.

5. Go to the Server Roles page and check the Public check box in the Server roles list.

6. Go to the User Mapping page, and then select 'LcsCDR' & 'QoEMetrics' databases.

7. Check the checkbox for db_datareader under database role membership.

8. Click OK.

9. In Exchange Reporter Plus, go to Skype for Business → Data Collection → SQL → Click Run Now to start gathering data.

Previous Topic Next Topic

Copyright © 2024, ZOHO Corp. All Rights Reserved.