October 8, 2008 at 2:39 pm
We've developed several SQL Server Reporting Services in SQL 2005. This Friday we're moving all of our reports from one server to another server. I've already moved our databases to the new server, but am not sure how I should go about moving the SSRS reports to the new server. I've copied the backups of the ReportServer and ReportServerTempDB databases from the old server to the new one; was that correct? Or should I have done something different? And is the job of moving the reports from off of the old server to the new server just an issue of getting into Visual Studio and deploying them to the new server, or is it something different?
Kindest Regards, Rod Connect with me on LinkedIn.
October 8, 2008 at 3:07 pm
Just deploy them to the new box via VS.
Heres the MS rabble about the DB's
http://msdn.microsoft.com/en-us/library/ms156421.aspx
Cheers,
Carlton..
October 8, 2008 at 3:46 pm
Thank you, Carlton.
Here's another question, which I meant to ask originally. How do I determine if SSRS is even installed on the server? Do I have to go through the SQL installation process to determine that, or is there any other way to do it?
Kindest Regards, Rod Connect with me on LinkedIn.
October 8, 2008 at 3:52 pm
Nope, theres many ways to check but just try connecting to it using Management Studio or RS config tool or checking in control panel.
cheers,
Carlton..
October 9, 2008 at 8:16 am
Carlton Leach (10/8/2008)
Nope, theres many ways to check but just try connecting to it using Management Studio or RS config tool or checking in control panel.cheers,
OK, I got into the RS Config tool on the new server, and it said that there was no report service found on that server. So, I guess that tells me it ain't there; I'll get the SQL Server installation DVD and put it on.
Kindest Regards, Rod Connect with me on LinkedIn.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply