Friday, May 11, 2012 7:04 PM
When I run reports present in SQL Server 2005 and SQL Server 2008 report from OpsMgr console and on few more reports, I am getting "One or more data sources is missing credentials" error.
I have granted my "Data Sources" with Secure credentials. But still I am facing this error on few reports. Also while opening report in Explorer, it is prompting for Credentials.
Please help me on sorting this out.
Friday, May 11, 2012 8:16 PM
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Friday, May 11, 2012 8:55 PM
Thanks for your reply.. Still same problem exist. As I have my Datawarehouse in different server, I have mentioned that server Netbios name in "data source".
Mostly I have used all the settings in "Data WareHouse Main " properties. Can someone help me to sort it out ASAP.
Thanks in advance!!!
Monday, May 14, 2012 6:55 AMModerator
It might be that these reports are not set to use the Data Warehouse Main data source. If you look at the data source of the specific reports that are erroring, make sure that they are using the correct data source.
Also check - http://SQLServerName/Reports - then drill down through Microsoft.SystemCenter.DataWarehouse.Report.librabry and open up Microsoft.SystemCenter.DataWarehouse.Report.Performance - and make sure that is using data warehouse main.
- Marked As Answer by bsuresh Monday, May 14, 2012 9:10 AM
Monday, May 14, 2012 9:10 AM
You made my Day!!! Thanks a ton for your reply. I have checked and mapped "Microsoft.SystemCenter.DataWarehouse.Report.Performance" to Data WareHouse Main.
It is working fine!!!