When configuring the Mart Server and the all fields within the Database Details are filled out correctly the following error prompt is received: "Data access error: Verify your credentials."
Steps to Reproduce:
- Click on the Configure Mart Server
- Fill in the following information in the Database Details:
- Database Type
- Port Number
- Server Name
- Instance Name
- Database Name
- Click the Configure button
Expected Results: The following prompt should be displayed: "The Mart database is connected successfully"
Actual Results: The following error prompt is displayed: "Data access error: Verify your credentials."
If the password is set correctly within the database; this issue could be due to the fact that the password is implicitly pointing to the database. For example: the password is set to "<password>@<database name>". The "@<database name>" at the end of the password is not allowed within the erwin Mart Configuration and should be avoided.
Change the password at the Mart database level to not include the Database name > fill in the Password within the Database Details > Click the Configure button.