Report Manager asks for credentials

[GeertVerhoeven]

Hi,

I've got 2 versions of Reporting Services installed (2000 and 2005).

Both are running on their own database (2000 and 2005).
When I launch reports from the 2005 version, everything works fine.

When I launch reports from the 2000 version the site first requests credentials. When I provide administrator's credentials it works.

Why does my site asks for credentials ?

Thanks in advance !

Geert

 

[henslecd]

You need to provide the credentials in the SQL 2000 data source when deploying.

 

[reportbert]

I've also noticed that in certain circumstances, data sources will repeatedly ask for credentials if you are not the owner of the .rds file.
You may be able to get around this if you have more permissions granted on the file, but i haven't been able to test that theory...