removing SQL Server 2005 (multiple Visual Studio versions)

I know that my entry which follows is rather long and complicated, but I am
hoping someone can offer helpful recommendations to my two questions at the
bottom. I have tried to research this and figure it out on my own, but I am
far from a computer SME, especially when it comes to behind-the-scenes stuff
,
and am afraid to attempt doing this on my own, out of fear of screwing my
situation up beyond repair. I have followed one recommendation from someon
e
in a Microsoft forum, but have not received a response in quite some time to
a question I posed regarding the current status. I felt I should pass alon
g
all the information I can, thus the length and complexity of this message.
So here’s my situation…
I have several versions of Visual Studio on my machine, and am looking to
uninstall EVERYTHING correctly to ensure a good installation of newly
purchased Visual Studio 2005 Professional Edition thereafter. I have found
several entries on the MS site (such as
http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend how
to remove previous installations, however, there are some differences in
their recommended order of removal of individual components. On my PC are:
Visual Studio .NET
Microsoft Development Environment 2002 (Version 7.0.9466)
Microsoft NET Framework 1.0 (Version 1.0.3705)
Installed Products:
Microsoft Visual C#.NET
Visual Studio .NET 2003
Microsoft Development Environment 2003 (Version 7.1.3088)
Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
Installed Products:
Microsoft Visual Basic.NET
Microsoft Visual C#.NET
Microsoft Visual C++.NET
Microsoft Visual J#.NET
etc.
Visual Studio 2005 – Team Suite edition trial download for which the
evaluation period ended, so I am unable to obtain environment information vi
a
opening the program.
Here is the list of programs/components on my PC displayed by the ADD/REMOVE
PROGRAMS utility. I have indicated before each component the version of
Visual Studio to which I believe it belongs. Please note that I do have SQL
Server 2000, and if possible, would prefer to NOT have to uninstall it, as I
have several working databases on it:
(2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
(2005) "Microsoft .NET Compact Framework 2.0"
(2002) “Microsoft .NET Framework 1.0 Hotfix (KB930494)”
(2002) “Microsoft .NET Framework 1.0 Hotfix (KB887998)”
(2003) “Microsoft .NET Framework 1.1”
(2003) “Microsoft .NET Framework 1.1 Hotfix (KB928366)”
(2005) "Microsoft .NET Framework 2.0"
(2005) “Security Update for Microsoft .NET Framework 2.0 (KB928365)”
(') "Microsoft Device Emulator version 1.0 – ENU"”
(2005) "Microsoft Document Explorer 2005"
"Microsoft SQL Server 2000"
(2005) “Microsoft SQL Server 2005 Mobile [ENU] Developer Tools”
(2005) "Microsoft SQL Server Native Client"
(2002) “Microsoft Visual C#.NET Standard - English"
(2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
(2005) "Microsoft Visual J# Redistributable Package 2.0"
(2003) “Microsoft Visual Studio .NET Enterprise Architect 2003 – Engl
ish”
(2005) "Microsoft Visual Studio 2005 Team Suite - ENU”
(2005) “Microsoft Visual Studio 2005 Team Suite – ENU Service Pack 1
(KB926601) (2005) “Security update for Microsoft Visual Stud
io
2005 Team Suite – ENU
(KB937061)
(2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtime"
(2005) "MSDN Library for Visual Studio 2005 BETA”
(2003) "Microsoft MSXML 4.0 SP2 (KB936181)
(2003) "Microsoft MSXML 4.0 SP2 (KB927978)
(2003) "Microsoft MSXML 4.0 SP2 (KB925672)
Following the Microsoft forum's recommendation, I used ADD/REMOVE programs t
o
remove SQL Server 2005, which resulted in the following components being
removed from the ADD/REMOVE programs list:
(2005) "Microsoft SQL Server 2005”
(2005) "Microsoft MSXML 6.0 SDK and Parser"
(2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
(2005) Microsoft SQL Server Setup Support Files (English) (version 9.0
0.
3042.00)
Now my questions...
1) I've tried to figure out why “Microsoft SQL Server 2005 Mobile [E
NU]
Developer Tools” is still on my machine, and I'm not sure how best to remo
ve
it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folder
contains only another folder labeled "Samples", which in turn contains only
a
third folder holding a .zip file named NorthWindOleDb.zip.
There was no error message output to the screen by the removal of Sql Server
2005, but the MSDN article in the knowledge base states that "if these steps
did not uninstall all the components", to follow a series of subsequent step
s
"Make sure that the Microsoft SQL Server Setup Support Files component is
installed...double-click the Servers\setup\sqlsupport.msi file on the
original SQL Server 2005 installation media." The problem is that I have a
trial download, and the disc I created to hold it causes my machine to freez
e
up when I insert it in the drive. There was no error message output to the
screen by the removal of Sql Server 2005, so, should I just use Add/Remove
programs to remove it from my machine (without the presence of Setup Support
Files), or would deleting the folder via Windows Explorer be OK?
2) Can I retain SQL Server 2000 and have a successful installation of VS 200
5
Pro Edition, which is supposed to have SQL Server 2005 included? (per
MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currentl
y
be on my machine...: "Do not uninstall the Microsoft SQL Server Native Clien
t
component if you have SQL Server 2000 components installed.")
Thanks in advance for your time and help!Hi
If you want to have different development environments on a machine you may
want to consider virtual machines.
Your post does not say if you have tried to remove “Microsoft SQL Server
2005 Mobile [ENU] Developer Tools” using the add/remove programs but t
hat
should be ok as it is listed as a separate installation.
I believe the SQL 2000 components are in reference to the backward
compatibility components for SQL 2005. The native driver should not be
necessary for SQL 2000 although having it installed should not cause any
issues.
For your SQL 2000 databases make sure that you have good backups of all the
databases (including system dbs), then if you do need to remove it and
re-install you don't have to worry about logins, jobs etc.
John
"gandecoe" wrote:

> I know that my entry which follows is rather long and complicated, but I a
m
> hoping someone can offer helpful recommendations to my two questions at th
e
> bottom. I have tried to research this and figure it out on my own, but I
am
> far from a computer SME, especially when it comes to behind-the-scenes stu
ff,
> and am afraid to attempt doing this on my own, out of fear of screwing my
> situation up beyond repair. I have followed one recommendation from some
one
> in a Microsoft forum, but have not received a response in quite some time
to
> a question I posed regarding the current status. I felt I should pass al
ong
> all the information I can, thus the length and complexity of this message.
> So here’s my situation…
> I have several versions of Visual Studio on my machine, and am looking to
> uninstall EVERYTHING correctly to ensure a good installation of newly
> purchased Visual Studio 2005 Professional Edition thereafter. I have foun
d
> several entries on the MS site (such as
> http://msdn2.microsoft.com/en-us/vstudio/aa718687.aspx and
> http://msdn2.microsoft.com/en-us/vstudio/aa718704.aspx) which recommend ho
w
> to remove previous installations, however, there are some differences in
> their recommended order of removal of individual components. On my PC are
:
> Visual Studio .NET
> Microsoft Development Environment 2002 (Version 7.0.9466
)
> Microsoft NET Framework 1.0 (Version 1.0.3705)
> Installed Products:
> Microsoft Visual C#.NET
> Visual Studio .NET 2003
> Microsoft Development Environment 2003 (Version 7.1.3088
)
> Microsoft NET Framework 1.1 (Version 1.1.4322 SP1)
> Installed Products:
> Microsoft Visual Basic.NET
> Microsoft Visual C#.NET
> Microsoft Visual C++.NET
> Microsoft Visual J#.NET
> etc.
> Visual Studio 2005 – Team Suite edition trial download for which the
> evaluation period ended, so I am unable to obtain environment information
via
> opening the program.
> Here is the list of programs/components on my PC displayed by the ADD/REMO
VE
> PROGRAMS utility. I have indicated before each component the version of
> Visual Studio to which I believe it belongs. Please note that I do have S
QL
> Server 2000, and if possible, would prefer to NOT have to uninstall it, as
I
> have several working databases on it:
> (2002) "Microsoft .NET Compact Framework 1.0 SP3 Developer"
> (2005) "Microsoft .NET Compact Framework 2.0"
> (2002) “Microsoft .NET Framework 1.0 Hotfix (KB930494)”
> (2002) “Microsoft .NET Framework 1.0 Hotfix (KB887998)”
> (2003) “Microsoft .NET Framework 1.1”
> (2003) “Microsoft .NET Framework 1.1 Hotfix (KB928366)”
> (2005) "Microsoft .NET Framework 2.0"
> (2005) “Security Update for Microsoft .NET Framework 2.0 (KB928365)
> (') "Microsoft Device Emulator version 1.0 – ENU"”
> (2005) "Microsoft Document Explorer 2005"
> "Microsoft SQL Server 2000"
> (2005) “Microsoft SQL Server 2005 Mobile [ENU] Developer Tools”
> (2005) "Microsoft SQL Server Native Client"
> (2002) “Microsoft Visual C#.NET Standard - English"
> (2003) "Microsoft Visual J# .NET Redistributable Package 1.1"
> (2005) "Microsoft Visual J# Redistributable Package 2.0"
> (2003) “Microsoft Visual Studio .NET Enterprise Architect 2003 – En
glish”
> (2005) "Microsoft Visual Studio 2005 Team Suite - ENU”
> (2005) “Microsoft Visual Studio 2005 Team Suite – ENU Service Pack 1
> (KB926601) (2005) “Security update for Microsoft Visual St
udio
> 2005 Team Suite – ENU
> (KB937061)
> (2005) "Microsoft Visual Studio 2005 Tools for Office System 2005 Runtim
e"
> (2005) "MSDN Library for Visual Studio 2005 BETA”
> (2003) "Microsoft MSXML 4.0 SP2 (KB936181)
> (2003) "Microsoft MSXML 4.0 SP2 (KB927978)
> (2003) "Microsoft MSXML 4.0 SP2 (KB925672)
> Following the Microsoft forum's recommendation, I used ADD/REMOVE programs
to
> remove SQL Server 2005, which resulted in the following components being
> removed from the ADD/REMOVE programs list:
> (2005) "Microsoft SQL Server 2005”
> (2005) "Microsoft MSXML 6.0 SDK and Parser"
> (2005) Microsoft SQL Server VSS Writer (version 9.00.3042.00)
> (2005) Microsoft SQL Server Setup Support Files (English) (version 9
.00.
> 3042.00)
> Now my questions...
> 1) I've tried to figure out why “Microsoft SQL Server 2005 Mobile [
;ENU]
> Developer Tools” is still on my machine, and I'm not sure how best to re
move
> it. Oddly, although it's listed in ADD/REMOVE programs, the Windows folde
r
> contains only another folder labeled "Samples", which in turn contains onl
y a
> third folder holding a .zip file named NorthWindOleDb.zip.
> There was no error message output to the screen by the removal of Sql Serv
er
> 2005, but the MSDN article in the knowledge base states that "if these ste
ps
> did not uninstall all the components", to follow a series of subsequent st
eps
> "Make sure that the Microsoft SQL Server Setup Support Files component is
> installed...double-click the Servers\setup\sqlsupport.msi file on the
> original SQL Server 2005 installation media." The problem is that I have
a
> trial download, and the disc I created to hold it causes my machine to fre
eze
> up when I insert it in the drive. There was no error message output to th
e
> screen by the removal of Sql Server 2005, so, should I just use Add/Remove
> programs to remove it from my machine (without the presence of Setup Suppo
rt
> Files), or would deleting the folder via Windows Explorer be OK?
> 2) Can I retain SQL Server 2000 and have a successful installation of VS 2
005
> Pro Edition, which is supposed to have SQL Server 2005 included? (per
> MSDN it's apparently OK for "Microsoft SQL Server Native Client" to curren
tly
> be on my machine...: "Do not uninstall the Microsoft SQL Server Native Cli
ent
> component if you have SQL Server 2000 components installed.")
> Thanks in advance for your time and help!
>