Team foundation Server problem looking for workaround with Default Instance problem

Question

Hello,

I have recently tried installing Visual Studio 2005 Team Foundation Server. One of the problems that I encountered was that the default instance that we are running is not MS SQL Server 2005, to change the default instance to 2005 would be a night mare for me and as such I was wondering if there is a way to install Visual Studio 2005 Team Foundation Server without changing the default instance to SQL 2005.

 

I appreciate any help you can give me in this matter.

Thanks,

Alex

 

Description
Default instance of SQL Server is not running Microsoft SQL Server 2005

Workaround / Remedy
The default instance of SQL Server is not running Microsoft SQL Server 2005. The default instance of SQL Server must be running Microsoft SQL Server 2005 before you install this product.

More information
For additional information and help please refer to: http://go.microsoft.com/fwlink/?LinkId=52502

Answer 1

Hi Alexander,

While not supported in TFS v1, it is possible to use SQL Aliasing to make this work.  There is a post in the forums that describes how to do this.

If you are curious, we are working on SQL Instance support in our next release.

marc

Answer 2

Here's the thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=283228&SiteID=1

Answer 3

Thanks James and Marc

Answer 4

just in case there are people who still want to install TFS 2005 the solution could be....

i tried several times to install TFS 2005 on Win 2003 with SQL 2005. i was getting the same error. my only SQL 2005 instance was not installed as "default". reinstalled SQL 2005 this time as default instance. problem resolved.