I have a question about sql server reporting service.
We currently have a sql server 2005 called for example sql1 that has reporting service installed.
We are going to move everything on the server to a new server called sql2. What we plan is move all the databases there first, then turn off sql1 and rename sql2 to sql1, this way all applications will connect to the new server without changing their connection
The thing I concerned is sql reporting service, I had experience before, if something wrong I need to uninstall and reinstall reporting service, it's hard.There is always something leftover after uninstall, I have to clear registry or uninstall all
sql server to fix that.
So I would like suggestions how to make a clean install or move for reporting service. I found some articles said if rename computer, the reporting service may not work. What is best way of doing this? I actually can redeploy those reports to the report
Shall I install reporting service after rename the computer to sql1? I will install sql server 2005, sp3. If so, after install service pack3, can I later install only reporting service? I mean this way sp3 will not apply to reporting service, how does this
Thanks in advance.
View Complete Post