Crystal Reports and Logon Failed.

[Michael O'Donnell]

Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run and
display ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with the
regristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put into
these fields, can anyone suggest a solution.

Michael

 

[Jorge]

Hi Michael

Have you tried the .ApplyLogOnInfo method for each table
of the report.

Kind Regards
Jorge

 

[Guest]

Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.

 

[Jorge]

Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge

 

[Guest]

Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********", database
= "pubs" and have checked the trusted connection option.
Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike

 

[Jorge]

Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the pubs
database.

Kind Regards
Jorge

 

[Michael O'Donnell.]

Hi

Am after repeating the steps again for the OLE DB (ADO)
and like you I left the integrated integrity unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissions
to see if that can help.

Michael O'Donnell.

 

[Jorge]

Well i am running out of suggestions i did use 'sa'
instead of 'administrator'.

Kind Regards
Jorge

 

[Michael O'Donnell]

If you used sa as a user ID, what did you use for the
password???

Michael

 

[Guest]

the blank password

-----Original Message-----
If you used sa as a user ID, what did you use for the
password???

Michael
.

 

[Guest]

When i use "sa" as a user id and leave the password field
blank, i get an error message telling me that "sa" is not
a trusted connection.

Mike

 

[neuromancer]

Anonymouswrote:
When i use "sa" as a user id and leave the password field

blank, i get an error message telling me that "sa" is not
a trusted connection.

If using the sa login you need to open up your ODBC connection and
change the login details from trusted connection to "use SQL login
name and password". Trusted connection tries to match a Windows
Domain login to associated rights within SQL Server, the other option
just uses internal SQl server authority.

David