While generating a report when MS SQL database is deployed, a blank screen or "There is no matching data for your input(s)" error is displayed
Ensure that the product is running before executing the troubleshooting steps listed below.
In the machine where ADManager Plus is installed, start a Command Prompt as an administrator.
Test the connectivity between ADManager Plus and MS SQL server by executing the following steps:
- Navigate to <Installation Directory>\ADManager Plus\bin directory and execute the ChangeDB.bat file.
- In the pop up that opens, click Test Connection.
- A pop will then display the connection status. If the connection test fails, ensure that the database wizard details are correct and check again. If the connection test is successful, try generating the report again.
If the MS SQL server is connected and the problem still persists, navigate to the <Installation Directory>\ADManager Plus\bin directory and execute the Bcp.exe command.
- If a "msodbcsqlxx.dll is missing" error occurs, then the DLL file must be replaced. Search for the appropriate DLL file as per your MS SQL version and download it.
- If a bcp.exe file is not recognized, copy the bcp.exe (<MS SQL Installation Dir>\Tools\Binn\bcp.exe) and bcp.rll (<MS SQL Installation Dir>\Tools\Binn\Resources\1033\bcp.rll) and paste them in ADManager Plus\bin.
New to ADSelfService Plus?
Related Articles
There is no matching data for your input(s) when generating the report
Possible cause: The report results have been filtered to show results only from the selected OUs. The help desk technician may not have access to the chosen OU. Solution: Remove the OU filter criteria in the desired report. You can do this by ...How to integrate ADManager Plus with Azure SQL database
ADManager Plus can be integrated with a list of databases to facilitate efficient AD management. This specific integration with Azure SQL database allows administrators to synergistically manage AD objects from their Azure SQL instance itself. ...How to integrate ADManager Plus with AWS SQL database
ADManager Plus can be integrated with a list of databases to facilitate efficient AD management. This specific integration with AWS SQL database allows administrators to synchronize data from AWS SQL to AD to efficiently provision user accounts and ...How to migrate ADManager Plus database to MS SQL in AWS?
Steps to migrate ADManager Plus database to MS SQL server in Amazon Web Services Login to your Amazon web services account. Click the Relational Database System (RDS) instance which has been created. Open command prompt in <Installation ...Error Message: Couldn't establish the establish database connection. Unknown server host name.
Error Message: Couldn't establish the establish database connection. Unknown server host name. Possible Cause: 1. Database is offline. 2. Renamed database files. 3. Moved the database to a new server. 4. Correct ODBC version is not installed on the ...