Production SSRS Report Issue

  • Hi All,

    Two days back we migrated one database from one server location to another server location, But now when we try to generate the report , We cant access it. We cant able to find errors also. What will be the issue

    Report server is in PST and SQL database is in CST.

    Kindly help on this

    Regards
    NM

  • Narine M - Friday, March 10, 2017 1:22 PM

    Hi All,

    Two days back we migrated one database from one server location to another server location, But now when we try to generate the report , We cant access it. We cant able to find errors also. What will be the issue

    Report server is in PST and SQL database is in CST.

    Kindly help on this

    Regards
    NM

    Can you be any more specific than 'We can't access it'? What happens, exactly?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Has the report's data source been updated?  I would assume if the DB isn't where it used to be that will need to be done.  Also, does the report user have read permissions on the DB in the new location?  Does the new DB server allow logins from the report server?  Those are some of the starting points I would check.

  • Yes, data source has been updated, the report server has read permissions and it allows logins also..

  • Look in the Report Server error log - that normally has the errors, and additional information,  encountered by the report server when running the report.

    Sue

  • As a thought, did you backup and restore the encryption keys when moving the SSRS database?
    And if this is SQL Standard, did you remove the entries to the old server as SQL Standard doesn't let you do failover clustering for SSRS?

    I recently migrated our LIVE SSRS to a test environment and got stumped for a little bit because it thought I was trying to setup failover when I was not.  Removed the entries from the dbo.Keys table in ReportServer database (made a backup first just in case it failed) and the problem went away.

    But it all depends on what errors you are getting.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • bmg002 - Tuesday, March 14, 2017 11:30 AM

    But it all depends on what errors you are getting.

    Pretty much why you'd likely want to check the error log to see how to proceed. 😉

    Sue

  • Sue_H - Tuesday, March 14, 2017 2:53 PM

    bmg002 - Tuesday, March 14, 2017 11:30 AM

    But it all depends on what errors you are getting.

    Pretty much why you'd likely want to check the error log to see how to proceed. 😉

    Sue

    I agree.  I was just trying to put some ideas out there about what I did when migrating SSRS servers that they may have missed.
    I wouldn't be surprised if it was encryption keys or that it was Standard and thought it was part of a cluster.
    But I could be wrong 🙂

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • bmg002 - Tuesday, March 14, 2017 3:12 PM

    Sue_H - Tuesday, March 14, 2017 2:53 PM

    bmg002 - Tuesday, March 14, 2017 11:30 AM

    But it all depends on what errors you are getting.

    Pretty much why you'd likely want to check the error log to see how to proceed. 😉

    Sue

    I agree.  I was just trying to put some ideas out there about what I did when migrating SSRS servers that they may have missed.
    I wouldn't be surprised if it was encryption keys or that it was Standard and thought it was part of a cluster.
    But I could be wrong 🙂

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply