March 10, 2017 at 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
March 10, 2017 at 1:34 pm
Narine M - Friday, March 10, 2017 1:22 PMHi 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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 10, 2017 at 5:36 pm
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.
March 14, 2017 at 12:51 am
Yes, data source has been updated, the report server has read permissions and it allows logins also..
March 14, 2017 at 10:50 am
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
March 14, 2017 at 11:30 am
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.
March 14, 2017 at 2:53 pm
bmg002 - Tuesday, March 14, 2017 11:30 AMBut 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
March 14, 2017 at 3:12 pm
Sue_H - Tuesday, March 14, 2017 2:53 PMbmg002 - Tuesday, March 14, 2017 11:30 AMBut 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.
March 16, 2017 at 3:21 pm
bmg002 - Tuesday, March 14, 2017 3:12 PMSue_H - Tuesday, March 14, 2017 2:53 PMbmg002 - Tuesday, March 14, 2017 11:30 AMBut 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