Published reports asking for database login info

Hi, CRXI/SQL 2000/Infoview
I’ve been publishing reports without a problem, now I publish a report to enterprise reporting and when the user opens it in infoview the report asks for the database user_id and password (only on a couple reports), this never happened before. Is it an option or something? I cant find a difference in options or report options between a report that opens and one that asks for the login info.

Please help


cjbrown :us: (BOB member since 2005-08-08)

Are all your published reports reading the same datasource? The only time this happens to me is when it is a new datasource and the server is not set up with the odbc connection.


Sharon_L (BOB member since 2006-09-29)

Yes it’s the same, nothings changed except that they (KMT) added a patch.


cjbrown :us: (BOB member since 2005-08-08)

Thanks for the heads up, I did notice that one (not working) is pointing at the server name as the data source, and the other (is working) is pointing at the database name as the data source. I’m not sure how to fix it though.


cjbrown :us: (BOB member since 2005-08-08)