I have what seems like a very weird problem. I wrote a report in Crystal Reports to connect to a SQL database. I have one domain login, that when I run it, everything runs fine on every computer. When I log in as any other AD Account, it gives me an error when it tries to bring up my prompts that says "Prompting failed with the following error message: "List of Values failure: fail to get values. [Cause of error: Failed to retrieve data from the database. Error in File UNKNOWN.RPT: Failed to retrieve data from the database.]. Error source pompt.dll Error Code 0x80034380D"
The ODBC connection is setup the same. on the machines. And I have created a brand new user, given them all of the exact same AD Groups as the one that is working, and still it doesn't work. I'm kind of at a loss because it seems to be AD Account specific but I can't find what is different about the one that works vs. the one that doesn't. I believe I set any DB permissions up the same as the one that is working too. At least the ones I know of.
Any light shed on this would be appreciated.
Thanks,
Brian