Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
Error: "One or more data sources is missing credentials"

Jawab Error: "One or more data sources is missing credentials"

  • Friday, May 11, 2012 7:04 PM
     
     
    Sign In to Vote
    0

    Hi,

    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.

    Regards, Suresh

     

All Replies

  • Friday, May 11, 2012 8:16 PM
     
     
    Sign In to Vote
    0

    Hi,

    Same issue here: http://qa.social.technet.microsoft.com/Forums/en/operationsmanagerreporting/thread/0a716754-b4fa-4755-99a9-213f0cbbc16c

    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
     
     
    Sign In to Vote
    0

    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!!!

    Regards, Suresh

     
  • Monday, May 14, 2012 6:55 AM
    Moderator
     
     Answered
    Sign In to Vote
    2

    Hi Suresh

    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.

    Cheers

    Graham

    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

    • Marked As Answer by bsuresh Monday, May 14, 2012 9:10 AM
    •  
     
  • Monday, May 14, 2012 9:10 AM
     
     
    Sign In to Vote
    0

    Graham,

    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!!!


    Regards, Suresh