"Logon failed" in Crystal reports when switching to a different database server

  • Thread starter Thread starter John Dalberg
  • Start date Start date
J

John Dalberg

Running Crystal Reports with the hotfixes and patches & VS 2003.

I created a CR report on my development server which has SQL Server. The
report runs fine inside Visual Studio. When I switched the source of the DB
to the production server using the 'set location' option in CR and ran the
app again, I get "Logon Failed" error message. The database wizard worked
fine so this tells me CR was able to connect and retrieve the schema from
the second server and permissions are ok. So why am I getting a "logon
failed" message? AFAIK, CR saves the logon info in the .rpt file.
 
Running Crystal Reports with the hotfixes and patches & VS 2003.

I created a CR report on my development server which has SQL Server. The
report runs fine inside Visual Studio. When I switched the source of the DB
to the production server using the 'set location' option in CR and ran the
app again, I get "Logon Failed" error message. The database wizard worked
fine so this tells me CR was able to connect and retrieve the schema from
the second server and permissions are ok. So why am I getting a "logon
failed" message? AFAIK, CR saves the logon info in the .rpt file.
Click to expand...

I found the answer.
KB 319264
 
Back
Top