Database problem

[Kasten]

Hi,

I have developed a report in CR 8.5 and now have a customer who wants to run it in CR 8.5 against another database. We have done the "Set Location" procedure and the database, server and table is changed to his. When the report is running (after 10000 records) he suddenly is prompted to log on the old (my) database. When he tries to log on his own the report stops. There are no subreports in the report.

Both databases are Microsoft Sql Server.

Can anyone help me with this problem?
Thanks

Fredrik

 

[JohnTcolo]

Make sure you close the report and log off the server, then reload the report-don't refresh and set the location. If that does not work, create a new datasource pointing to the right server/db.