Troubleshooting

General Gathering Task


Remote Powershell network error

Logon failed. Invalid username or password.

Insufficient privilege for the user.


SQL Gathering Task


Login failed for user 'username'.

Connection failed for SQL Instance(s)

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

Copyright © 2023, ZOHO Corp. All Rights Reserved.