Jump to content


SpacePants

Established Members
  • Posts

    7
  • Joined

  • Last visited

Posts posted by SpacePants

  1. So, should anyone have the same problem this is what I did:

    • Remove Reporting services role from SCCM, closed console.
    • Ran sql 2008 installer with a view to removing reporting services - it reported reporting services was not installed. (weird)
    •  Ran sql 2014 installer with a view to removing reporting services - it reported reporting services was not installed. (OK, that's also weird).
    • Unattached the current SQL Report server and Report Temp DB databases.
    • Reinstall SQL 2014 report services.
    •  
    • Registered Reporting URL and created reporting databases  in Reporting Services Configuration Manager 2014
    •  
    • Installed the Reporting services role in SCCM - (Warning - I had the blank database problem described here http://myitforum.com/myitforumwp/2012/10/10/reporting-services-site-role-setup-instance-blankempty/I followed the instructions in this post and all is OK now.

    Thanks for the help and advice offered by all.

     

     

  2. @sccm_buff = thanks for the information.

    Something obviously went wrong here with my reporting services upgrade - I have a MSRS10_50.MSSQLSERVER folder (SQL 2008) but I don't have a MSRS 12.MSSQLSERVER  directory (SQL 2014 ) as I would expect in the directory C:\Program Files\Microsoft SQL Server.

     

    I will reinstall today or tomorrow and report back.

     

     

  3. Thanks for taking a look guys.

     

    @GarthMJ = understood, I configured RBAC ages ago, only two other admins can run reports and yes the did use the website . I have (or had) some scheduled reports that fire once a month so I want to get this fixed  before they fire off. thanks for taking a look at my post :) I'll try my steps tomorrow or Wednesday and report back to this forum., hopefully if someone else has this problem they may find this post.

    @sccm_buff = You had the same problem, was t after a SQL upgrade? Thanks for the detailed steps. I shall try the whole removal/reinstall of reporting services tomorrow or Wednesday. I may actually have a backup of my reports, I think may have done this before I upgrade from SCCM 2012 R2 to current branch last year. hopefully this won't be such a PITA (famous last words).

    Has anyone else come across this problem?

    Does anyone have any other comments before I make this change?

     

     

     

  4. Hi All.
    Long time lurker here but now is the first time I have been moved to create an account and ask for  some advice.  I’m looking for a bit of direction on how to proceed as I’m a bit stuck, I’d like to fix this without breaking anything else in SCCM.

     

    I’m running SCCM build 1606 – Last week we upgraded the SQL instance hosting all out SCCM databases from SQL 2008 SP3 to SQL 2014 (this because we plan to upgrade to SCCM 1702). The SQL upgrade wizard reported  that it upgraded all components  successfully to SQL 2014 but when I opened the SCCM console all the reports are missing. Everything else in SCCM appears to be OK.

     

    Further investigation revealed.

     

     

    • The Sql server Reporting services Service  is not running  - when I try and start it I get the error “ Error 2 – can’t find the service specified”. It turns out the executable it maps to named ReportingServicesService.exe  does not exist in "C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin
    •  
    • If I try and launch the SQL reporting services configuration manager 2008 and 2014 console it is unable find a reporting server.

     

    So I guess SQL reporting is broken.

     

    I’m wondering what I should do to try and fix this. This is what I was thinking but it’s just a guess.

     

    • Remove Reporting services role from SCCM.
    •  
    • Uninstall SQL 2008  Reporting Services  feature?
    •  
    • Uninstall SQL 2014 Reporting services Feature?
    •  
    • Unattached the current SQL Report server and Report Temp DB databases (would I need to do this?).
    •  
    • Reinstall SQL 2014 report services, configure reporting service point.

     

     

    I’d a appreciate any advice, I did have a few custom reports configured but I don’t mind setting them up again. The main thing is to get reporting services up and running again.
    Thanks in advance.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.