Storing Login Info

Is there a way to store the password for the database so that the user does not have to enter it every time?

Forums: 

Generally, you can save the username and password. The details on how to do this generally depend on your database type, and the way you are connecting to it.

Override the database connection with the "Server" and the "Database" fields both containing your ODBC DSN. Then it should work fine.

My report is actually accessing 2 databases from the same server. How do I handle that? It seems that the override will only allow me to choose one.