Prompt for DB Username and PW

[TCavins]

I am accessing reports from an ASP page passing them to the report that is displayed in the ActiveX viewer for Crystal.

I am using the Native driver for SQL Server to access the database.

The reports run fine most of the time. Every once in awhile a user will be prompted to enter in the UserID and Password to access the database. Even if I type in the right information, the dialogue box pops back up and the report is never displayed.

Does anyone know why this might be happening and if there's a possible solution to it?

Thanks,

Tim

 

[Tracey]

Are you running the pageserver as a service?? I had the looping logon problem which was (and still is) solved only by running the pageserver from the windows "run":

"c:\progra~1\seagat~1\wcs\pageserver.exe -cache -deletecache -console"

 

[TCavins]

Wouldn't it do it everytime though if it was a result of it running as a service?

 

[Tracey]

well, mine did.

just thought it might be worth a try.