Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Requesting Logon

Status
Not open for further replies.

bnorman

MIS
Jun 18, 2004
8
US
Hi all,

We have an intranet website that we have deployed CR10 reports on. We use .ASP to call the report.

These reports run fine on my development machine.

The reports that hit an AS400 database work fine.

The problem is that when we deploy a report that hits an excel spreadsheet or access database the report comes back and asks for a User name and password.

The .ASP is passing a user name and password for the AS400 database, but not for the other type of database.

This can't be the problem though as when a report is hitting only an excel or access database it will still ask for a username and password.

The other data structures are not saved with a password so I don't understand why it is asking for this?

Remember, these reports have no problem opening up in the application on my development machine. It is only when deployed.

Thanks

Bruce
 
Hi,
The request is probably due to permissions set for the Access/Excel directories.

Check on how to grant the IUSR_ (anonymous) type accounts ( which IIS uses to communicate with other servers) permission to acces those locations..

[profiles]

PS, when you run it on your machine, it uses your account which probably has permission.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top