How to Resolve Database Login Error
Introduction
This knowledge base article will assist you in resolving the Database Login Error, which is a common error, which occurs in Crystal Reports. Going through this article, you will learn about the error overview, the reason for the error and the solution to resolve the error.
Overview
The iVend Database and SQL Database remain connected and the reports are synchronised automatically. There are a few common errors that are observed when the connection string doesn’t refresh between the iVend Retail Database and SQL Server.
Reason
The Database Login Error occurs when the Crystal Report Viewer fails to refresh the database server connection.
The following screen image illustrates the Database Login Error where it is asking for the SQL Login Id and Password for the configured server and database information. After entering the login details when you click the Finish button, a message box appears showing “Login Failed. Please try again.” Click the [Ok] button and follow the steps mentioned in the section below, Solution to Resolve the Error.
Solution to Resolve the Error
To resolve the Database Login error, follow these steps:
Open the OLEDB (ADO) dialog box.
1. Open the report in Crystal Report Designer.
2. On the Database menu, click Verify Database.
1. Enter the correct server information of the server and database from which the error is thrown.
2. Click the [Finish] button.
Once you have completed troubleshooting, check the report preview and save it. Again, import this report through the iVend Report Manager.
Related Articles
Cannot open database 'CXSIntegration' login failed
Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...Found error while login MC "Error encountered found in application"
Environment: 6.6.7989 Short Description: Error found in the application Product Query: While login in Management Console found error “Error found in the application” Resolution/Work Around: Not Applicable Recommendations /Suggestion: Ivend Database ...ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Error while login to Management Console, error message says "Unable to validate license"
******* Internal to CitiXsys ******** Environment: Not Environment specific Problem Statement: Facing following error while login to MC and not able to login to MC, error message says "Unable to validate license" Symptoms: Not able to login to ...How to Resolve Timeout Expired Error
How to Resolve Timeout Expired Error This knowledge base article will assist you in resolving the Timeout Expired error, which is a common error that occurs in .IRT extension type reports (iVend Retail Report Designer reports). Going through this ...