SQL Server 2000 and SQL Server 2005

29 Dec 2005 7:17 AM

Raja

How to configure SQL Server 2000 as default instance, while having installed
SQL Server 2005 beta, on the same server?

As, VS Team suite needs SQL Server 2005 as a default instance. But, my
application needs SQL Server 2000 as a default instance. If not possible,
how we can have both versions of Database installed in same machine.

29 Dec 2005 7:29 AM

Roger Wolter[MSFT]

You can only have one default instance. You need to chose one as the
default and make the other one a named instance. You have to change the
connection string of one or the other applications

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Show quote

"Raja" <sr291***@gmail.com> wrote in message
news:%23fRpbeEDGHA.532@TK2MSFTNGP15.phx.gbl...
>
>
> How to configure SQL Server 2000 as default instance, while having
> installed SQL Server 2005 beta, on the same server?
>
>
>
> As, VS Team suite needs SQL Server 2005 as a default instance. But, my
> application needs SQL Server 2000 as a default instance. If not possible,
> how we can have both versions of Database installed in same machine.
>
>
>
>

29 Dec 2005 9:10 AM

Raja

Team Foundation Server setup will fail if you specify a named instance,
while installing SQL Server 2005 (During instllation of Team Foundation
Server). As, my application

needs a "Default Instance" of SQL Server 2000, is there any other way,
having both the installtions together, with SQL Server 2000 (Default
Instance) , SQL Server 2005 with named instnce to run Team Foundation
Server.

Thanks,

Raja

Show quote

"Roger Wolter[MSFT]" <rwol***@online.microsoft.com> wrote in message
news:uO3sdmEDGHA.2704@TK2MSFTNGP11.phx.gbl...
> You can only have one default instance. You need to chose one as the
> default and make the other one a named instance. You have to change the
> connection string of one or the other applications
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Raja" <sr291***@gmail.com> wrote in message
> news:%23fRpbeEDGHA.532@TK2MSFTNGP15.phx.gbl...
>>
>>
>> How to configure SQL Server 2000 as default instance, while having
>> installed SQL Server 2005 beta, on the same server?
>>
>>
>>
>> As, VS Team suite needs SQL Server 2005 as a default instance. But, my
>> application needs SQL Server 2000 as a default instance. If not possible,
>> how we can have both versions of Database installed in same machine.
>>
>>
>>
>>
>
>
>
>
> ---
> avast! Antivirus: Inbound message clean.
> Virus Database (VPS): 0550-3, 12/15/2005
> Tested on: 12/29/2005 2:35:47 PM
> avast! - copyright (c) 1988-2005 ALWIL Software.
> http://www.avast.com
>
>
>

SQL Server 2000 and SQL Server 2005 - Installation issues