Removing Constant Password Prompt
If everything is working correctly, but the software forces your user to enter a username and password at each refresh, you can override just the username and password to bypass the constant prompting?
Databases can be set to require your user to enter the username and password at each refresh. There's a way around that.
You can override the database connection, setting only the username and password. This will leave the other connection settings inside the report the same, and set the password for each database inside the report.
Other Connection Issues
If you are setting up the software, and you are getting a "failed to connect" error, or something similar, read this information about the error, and read this document for tips on overriding the database connections.
If you are unable to get the software to connect to the data-source, you can ask us for assistance.