robthomas09
asked on
Crystal Reports - Logon Failed - Command
Hello experts,
I have a crystal report that is built with a command. I log in with the admin SA and PW when I built the report in Crystal. It previews in Crystal just fine.
However, when I try to run the report from within my application, I get an error message that says "Logon Failed" and that's it. I am not logging into the application as an admin, but I have other reports that run in the same fashion and seem to run just fine from the application. It's almost as if the user credentials arent saved or cached with the command. There are plenty of sub-reports as commands as well.
Thoughts?
Thanks!
I have a crystal report that is built with a command. I log in with the admin SA and PW when I built the report in Crystal. It previews in Crystal just fine.
However, when I try to run the report from within my application, I get an error message that says "Logon Failed" and that's it. I am not logging into the application as an admin, but I have other reports that run in the same fashion and seem to run just fine from the application. It's almost as if the user credentials arent saved or cached with the command. There are plenty of sub-reports as commands as well.
Thoughts?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is the report set to use integrated security or SQL authorization?
Does the user see a login screen?
mlmcc
Does the user see a login screen?
mlmcc
ASKER
the user does not. I dont see a user name in the properties area of the command so I assume that's integrated yes?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I clicked add new connection, chose ODBC, my database name, entered the sa and pw, and it showed up in my view. When I look at the database properties in Crystal, the "Use DSN default properties" is set to False.
How else can I tell if I set it to use integrated security? I thought that if I dont see a user name in the properties area of the command then that's integrated?
How else can I tell if I set it to use integrated security? I thought that if I dont see a user name in the properties area of the command then that's integrated?
ASKER
It was a problem with permissions as described above. Syncd up users. Thanks!
ASKER
Yes the user is a SQL admin with db owner privs.