October 14, 2011 at 4:30 am
Does anyone know how to go about moving reporting services to another computer without moving the database. In my case, reporting services is installed on server A whilst the database is on server B. Server A is being replaced by newer hardware giving me server C & I want to put reporting services onto server C utilising the database on server B.
Is this possible? Do I still need to recreate all the reports & schedules?
Any pointers would be greatly appreciated.
Thanks
October 14, 2011 at 4:39 am
you should be able to just install report services on your new server, and then go into reports configuration manager on that new server and under the database tab point to the database on your old server.
October 14, 2011 at 4:42 am
Ah, that simple.
Is there a way of moving all the existing reports, subscriptions and data sources or is that manual?
October 14, 2011 at 4:44 am
All that stuff is what is located in the report server database, so you should not have to do anything aside from selecting the database.
October 14, 2011 at 4:48 am
Ah, that simple 😀
Maybe today is looking so bad after all.
Your assistance much appreciated.
October 14, 2011 at 4:51 am
Balance (10/14/2011)
Ah, that simple 😀Maybe today is looking so bad after all.
Your assistance much appreciated.
dont forget to change the deployment location in BIDS as well,
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply