I'm having an odd problem. Reports work fine with usernameA and usernameB in our alpha environment. Move it to our beta environment, which should be the same. Upon testing, usernameA works fine, however, usernameB fails to run the report with the following error:
Cannot create a connection to data source 'datasource'. (rsErrorOpeningConnection)
- Unexpected return code: 1
Grants and permissions are correct for both usernames in both environments, the procedures are the same, the reports are the same. Any ideas on what this error means?