We need to install sql server 2005 on a new computer for example sql2. We currently have an exiting one called sql1 without reporting service installed.
After the new server installation, then I will apply service pack 3, and restore databases, Then we will turn off sql1, and rename the new server to sql1.
My question is about reporting service.
Shall I install reporting service on the new server after or before rename server?
I searched it may have problems with reporting service after renaming the server.
So I think it may be better to install sql
reporting service after I rename server.
But then reporting service is not SP3, correct?
Will that work?
View Complete Post