Symptom
When creating a connection to a universe in Crystal Reports and
clicking OK in the Business Objects Query Panel, the following
error message appears:
Crystal Reports: "Logon failed".
However the SQL query is generated correctly.
Crystal Reports: "Logon failed".
However the SQL query is generated correctly.
Cause
The authentication mode is preventing the access to the
connection.
Resolution
In Business Objects Designer > Tools > Connections >
select the connection on which the universe is based > Edit and
make sure "Use single Sign On when refreshing reports at view time"
is not checked.
If you change this setting, make sure you re-export the universe to the system repository.
If you change this setting, make sure you re-export the universe to the system repository.
Keywords
In Crystal Reports error message "Logon failed" after creating connection to a universe , 1367949 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports XI ; SAP Crystal Reports XI R2