כניסה
 
עמוד הביתספריהלמדהורדותאיתר וטיפל בבעיותקהילהפורומים
משאבים למומחי מחשוב >
> 
> 
the service manager data warehouse sql reporting services server is currently unavailable

Unanswered the service manager data warehouse sql reporting services server is currently unavailable

  • יום חמישי 25 אוגוסט 2011 15:19
     
     
    היכנס כדי להצביע
    0

    My environment:

    Service Manager mangement server on VM with SQL

    Service Manager data warehouse management serever on VM with SQL

    Using domain accounts for all authentication access. domain SM_admin group added to the local admin group on both servers.

     

    The installation was successfully completed.

    When I attempt to register with the Service Manager Data Warehouse from the System Center Service Manager Console;

    - the Data Warehouse option is populated into the control panel

    Then a message appears...

    "The Service Manager data warehouse SQL Reporting Services server is currently unavailable. You will be unable to execute reports until this server is available. Please contact your system administrator. After the server becomes available please close your console and re-open to view reports."

     

    I have verified that the Report server is availble and I can browse to the URL successfully.

    Firewalls on both the servers have been switched off - for now.

    The DNS suffix is populated in the relevant network fileds... refer to this post...

    http://donnystyle.wordpress.com/2011/08/23/reporting-data-warehouse-management-server-is-currently-unavailable-sysctr/#more-948

     

    I have closed and open the SCSM console several times and rebooted both SCSM servers, yet this message persists.

    This appears to be quite a common issue and the message is not intuitive or helpful!

     

    Please help?

     

    thanks, --samuel

     

     

     

     

     

כל התגובות

  • יום שישי 26 אוגוסט 2011 06:47
    מנחה דיון
     
     
    היכנס כדי להצביע
    0

    I have verified that the Report server is availble and I can browse to the URL successfully.


    Have you verified that you can access the URL from the SCSM mgmt. server aswell?

    Regards
    //Anders

    Anders Asp | Lumagate | www.lumagate.com | Sweden | My blog: www.scsm.se
     
  • יום שישי 26 אוגוסט 2011 11:53
     
     
    היכנס כדי להצביע
    0

    yes, I am able to acces the Reportserver URL from both SCSM servers.

     

    Thanks,


     
  • יום ראשון 28 אוגוסט 2011 13:15
    מנחה דיון
     
     
    היכנס כדי להצביע
    0

    And what about your report user; is that account working as it should? Try logging in on the mgmt. server with that account and see if you can access the reporting url.

    Regards
    //Anders

    Anders Asp | Lumagate | www.lumagate.com | Sweden | My blog: www.scsm.se
     
  • יום רביעי 31 אוגוסט 2011 13:14
    מנחה דיון
     
     
    היכנס כדי להצביע
    0

    I was at a customer yesterday which had the exact same issue, and the problem there was their proxy. Do you use a proxy?

    Regards
    //Anders

    Anders Asp | Lumagate | www.lumagate.com | Sweden | My blog: www.scsm.se
     
  • יום שלישי 08 מאי 2012 19:52
     
     
    היכנס כדי להצביע
    0
    thats correct. proxy settings may cause this problem as well.
     
  • יום שלישי 04 ספטמבר 2012 09:53
     
     
    היכנס כדי להצביע
    0
    Also take a closer look at the certificates where the reporting server is running under. I had it running with a self-signed certificate and this was not trusted on my workstation where i'm running the console. After importing the certificate so that it's trusted error was gone and problem solved.

    Andre van den Berg


    • נערך על-ידי Andre van den Berg יום שלישי 04 ספטמבר 2012 09:53
    •  
     
  • יום רביעי 06 מרץ 2013 16:44
     
     
    היכנס כדי להצביע
    0
    I had this problem because SQL Server Reporting Services was stopped after unexpected shutdown