We run Crystal reports from a vbscript passing the parameters to it from SQL files. The Crystal Report then uses the params to run a Stored Proceedure on SQL to gather data for the report. This particular report uses stored proc on another SQL server. All was working well until Administrator changed the loginname and password. Now the Report won't run. I used the set location and entered the new userid and password, but the report fails on the server.
If I use Crystal reports from my PC and enter the parameters it goes to the other SQL server and returns the data. Any Ideas on what I can do to resolve the problem.
If I use Crystal reports from my PC and enter the parameters it goes to the other SQL server and returns the data. Any Ideas on what I can do to resolve the problem.