Which product are you using InfoView with? Crystal Server?BusinessObjects?
On the server where that software is installed, a couple of things need to happen:
1. The server needs to have the SQL Server client software installed, including the OLE DB drivers.
2. The "server processes" on that server, in particular the Crystal Reports Processing Server need to be run using a network service account. The default is for them to run using the local service account on the server. This account doesn't have access to any network resources. Best practice is to set up a service account on the network that has a password that doesn't expire and then up all of the relevant parts of Crystal Server or BusinessObjects to use that account.
In addition, after you publish a report using Crystal, you need to log in to the Central Management Console (CMC), navigate to the report, and set the Database properties on the report so that it knows which userID and password to use for its connection to the database. You have to do this EVERY TIME you make changes to the report and re-publish it.
-Dell
IP Logged
