Using Crystal Reports 2008, I have 2 Sybase (SQL Anywhere 9) databases connected to a single server, one is the original database used by my app, the other is a mirror that I want to run reports against.

If I add a new user to both databases, I can connect to the mirror via an OLE DB connection without a problem.

However, to prevent users from connecting to and running reports against the main database, I've changed the user so that they have a password in the mirror database, but not in the main database.

The problem is, after making this change, when I try to connect to the mirror database I get an "Invalid user ID or password" error.

I can connect to the mirror database as this user from other applications, it only seems to be Crystal Reports that has the problem.