I know that SQL Server 2000 and 2005 can reside on the same machine, but can
I safely install SQL Server 2000 on a machine *after* SQL Server 2005 has is
already been installed?
O/S: Windows XP Pro

Thanks, Douglas

I strongly recommend not trying it. Microsoft recommends against it also,
and I am not sure what your status would be as far as support goes (for the
2005 instance, since 2000 is officially out of its support lifetime).

Can you get by using a database in 2005 but in 2000 compatibility (80)?



On 5/12/08 11:06 PM, in article #ILyCYKtIHA.4476@TK2MSFTNGP06.phx.gbl,
"dbuchanan" <dbuchanan@newsgroup.nospam> wrote:

> I know that SQL Server 2000 and 2005 can reside on the same machine, but can
> I safely install SQL Server 2000 on a machine *after* SQL Server 2005 has is
> already been installed?
> O/S: Windows XP Pro
>
> Thanks, Douglas
>
>

Hello Douglas,

Though it's not recommended, you could install SQL 2000 after SQL 2005.
However, there are some known issues and you may want to refer to the
following articles for more details:


905618 You may receive a connection error message when you try to connect
to an instance of SQL Server 2000 or of SQL Server 7.0 that was installed
after you installed SQL Server 2005
http://support.microsoft.com/default...b;EN-US;905618


922131 You cannot remotely connect to a named instance of SQL Server 2000
by using the TCP/IP protocol
http://support.microsoft.com/default...b;EN-US;922131

917406 Error message when you try to modify a SQL Server 2000 DTS package
in SQL Server 2005: "The DTS host failed to load or save the package
properly"
http://support.microsoft.com/default...b;EN-US;917406


If anthing is unclear, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Peter,

Thank you for your reply.

Since I wanted to install it for the purpose of connecting to another
instance through TCP/IP then I will want to uninstall SQL Server 2005 first
before installing SQLS2000

I have a few question, but first a couple of facts:
My OS is Windows XP Pro 32-bit (SP3)
SQL Server 2005 is (SP2)
This system is set up for development purposes only.

How to uninstall?
SQL Server 2005 installs a lot of stuff and I am not exactly sure what I
need to uninstall.

Do I have to tediously uninstall each component or is there a way to
uninstall everyting I need to thorugh the installation disk?

If not below is a list of related installed components on this machine. (you
will see I have Visual Studio 2005 also installed). What do you suggest I
need to uninstall? before installing SQL Server 2000.

[o] Indicates what I think can stay.
[x] Indicates what I think must be uninstalled.

[o] Microsoft NET Compact Framework 1.0 SP3 Developer Size 9.87MB
[o] Microsoft NET Compact Framework 2.0 Size 59.27MB
[o] Microsoft NET Framework 2.0 Service Pack 1 Size 186.00MB
[x] Microsoft Device Emulator version 1.0 - ENU Size 1.38MB
[o] Microsoft Document Explorer 2005 Size 26.61MB
[o] Microsoft Office 2003 Web Components Size 22.69MB
[x] Microsoft SQL Server 2005 Size 1,319.00MB
[x] Microsoft SQL Server 2005 Backward compatibility Size 26.35MB
[x] Microsoft SQL Server 2005 Books Online (English) Size 123.00MB
[x] Microsoft SQL Server 2005 Mobile [ENU] Developer Tools Size 66.95MB
[x] Microsoft SQL Server Native Client Size 4.20MB
[x] Microsoft SQL Server Setup Support Files (English) Size 20.60MB
[x] Microsoft SQL Server VSS Writer Size 0.43MB
[o] Microsoft Visual it 2.0 Redistributable Package Size 124.00MB
[o] Microsoft Visual Studio 2005 Premier Partner Edition - ENU Size 184.00MB
[o] Microsoft Visual Studio 2005 Professional Edition - ENU Size 812.00MB
[x] MSXML 6.0 Parser (KB933579) Size 1.31MB
[x] SQLXML4 Size 2.60MB

(By the way this is a Virtual Machine and I can back it up before I
uninstall just for protection)

Thank you,
Douglas

Hello Douglas,

I suggest that you uninstall SQL Server engine directly via Add/Remove
programs directly:

[x] Microsoft SQL Server 2005 Size 1,319.00MB

Other components are not directly related to SQL engine/connections.

If you have any update, please feel free to let's know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Peter,

This worked for me. I now have SQL Server 2000 & 2005 as my project
required.

Thank you for your direction.

Douglas

Hello Douglas,

My pleasure!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.