Sql reporting services on another instance on the data tier
Hi there,
I am attempting to upgrade team foundation server from RC to RTM. I have a dual server setup. On the data tier server, reporting services is installed but on a different SQL server instance as opposed to the default instance used by tfs. We use the reporting services installation for other purposes. We use a separate app tier server for tfs which will have reporting services installed.
Unfortunately, the tfs installation on the data tier fails after the pre-requisites check due to the presence of reporting services. Is there any work-around other than un-installing reporting services, for ex: disabling the installation from checking for the presence of reporting services on the data tier.
It will be very painful :( for us to un-install and re-install reporting services just to upgrade team foundation server. I'd be grateful for any suggestions.
Thanks, ~ p
dotNetFan
Are you using SQL Server Enterprise Edition on your DT?
John Morris
We're using SQL Server 2005 Developer edition.
Thanks, Prashanth
dotNetFan
We have not tested RS being on an instance of Sql. I believe we require RS to be on the default instance since we try to set it up that way. I think you have come up with the only suggestion possible.