crystal report hitting database before I type in the password?

[ksbigfoot]

I am using CR10.
I open up a crystal report in the crystal reports editor.
I run the report and it prompts me for the parameters.
I type in the parameters into the report and then it prompts me for the password (already displays username and ODBC pointer).
BEFORE I type in the password, I check on server that is running SQL Server 2000 in the event log and I get an error message stating,
Login failed for user 'MyUser'.

I then type in the password and the report runs fine.

My quesion is how come the crystal report is prompting the SQL Server database before I type in the password?

Thanks

 

[Madawc]

Is the password using database values?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

Any subreport?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ksbigfoot]

Howdy Madawc & Ido,
Madawc, I am not sure what you mean by "using database values". I type in my password after the log in the event viewer and my report comes out successful.

Ido, no testing on just a simple report, no subreports.

Seems like my system is prompting the database first, realizing that it needs a password, then comes back and prompts for a password.

Thanks for your help.

 

[Bontebok]

My guess is that the TestConnectivity method is run by default first to check credential-less database connections or possibly trying to authenticate using NT pass-through authentication.

This is probably something that will always happen unless you supply the RDC/.NET components with a login and password before the report is executed.

(maybe)

Bontebok

 

[ksbigfoot]

Howdy Bontebok,
Thanks for the post.
SQLBill mentioned that If I updated my service packs that it might get rid of that error message. I haven't run any service packs on SQL Server 2000 yet, so I will do that first to see if gets rid of the messages.
Thanks again for the post.
ksbigfoot.