Problem installing TFS on a machine with both SQL 2000 & 2005
The only machine I've got available to install TFS is a machine that already has a SQL Server 2000 instance. I installed SQL Server 2005 CTP (as instance SQL2005Beta), but TFS doesn't want to install because it says that Analysis Services and Reporting Services are disabled or missing.The problem appears to be that the TFS single-server install is accessing the default instance - SQL Server 2000 (which doesn't have Reporting or Analysis Services enabled). They're both enabled in the 2005 instance, but evidently aren't being accessed.
Is there any way I can scoot around this problem without uninstalling the SQL Server 2000 instance?
Thanks in advance
Josh
Now technically, the only difference between running default vs an instance is the /<instancename>. While Beta2 was not tested for instances, you may want to place the <machinename>/<instance> for the sql server. However, this may not work.
It might work, but like Bruce I doubt it. In fact, I can think of cases where I know this won't work.
I will tell you though, that others have tried this unsuccessfully -- but I don't know exactly what they did. In the end, they had to have SQL 2005 as the default instance and SQL 2000 as a named instance.
Marc
>> In the end, they had to have SQL 2005 as the default instance and SQL 2000
>> as a named instance.
Thanks for the heads-up. But is there a way I can rename the instances without a ton of pain?
Josh
Bruce Taimana MSFT wrote: