Crystal Enterprise V10 Login issues

[Former Member]

We have the Enterprise software loaded and initially was working with two levels of login. First login to access the list of web reports available, and the second login was connect to LDAP which authenticated the HNE person - this login gave access to run the report. In our endeavour to remove one level of login, we initially succeeded with some reports and not with other reports. the unsuccessful reports gave Error message - "there was an error retrieving data from the server: *Unable to connect: incorrect log on parameters."

Now, just last week we were blocked from accessing all reports, receiving the error message - "there was an error retrieving data from the server: Object does not support this property or method."

We now have a web portal with reports in view, but cannot open them.

Assistance is desparately needed, regards Sandra E.

[BasicTek]

If you have the reports set to SSO then kerberos is required, I don't think this was well documented back in CE10. Change the reports back to using username and password and either prompt or fill in a proper user/pw in the CMC.

Regards,

Tim

[Former Member]

Hi Tim

Thank your for your feedback.

Following confirmation from our IT people, I believe this is on the wrong track as we are not using SSO, we are using an ODBC connection with a named DSN using a specific database user.

Regards Sandra E

[former_member142702]

What kind of data source do you access with your reports?

What did you exactly do in order to " remove one level of login" as you say?

I assume the the list of the reports is still visible and that you get the error when you try to open those, correct?

Regards,

Stratos

[Former Member]

Hi Stratos

In answer to your questions, I can provide the following information: -

1. The data source is SQL Server 2000.

2. We did not really remove one level of login, what we actually did was make the server software use an ODBC DSN to the pathlore database. Previously it required a user name and password (as it was using Windows authentication and the server services were running under the LocalMachine\System account which has not network privilege. So now we have a"pass through" connection using an ODBC connection to the database. This should be configured the same on the server and on the development machine (which we have confirmed).

3. Yes the reports are visible, the error only appears when they are run.

Regards Sandra