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 someone
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 along
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 via
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 â' Englishâ'
(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 Studio
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 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 remove
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 steps
"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 freeze
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 2005
Pro Edition, which is supposed to have SQL Server 2005 included? (per
MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currently
be on my machine...: "Do not uninstall the Microsoft SQL Server Native Client
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 that
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 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 someone
> 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 along
> 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 via
> 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 â' Englishâ'
> (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 Studio
> 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 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 remove
> 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 steps
> "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 freeze
> 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 2005
> Pro Edition, which is supposed to have SQL Server 2005 included? (per
> MSDN it's apparently OK for "Microsoft SQL Server Native Client" to currently
> be on my machine...: "Do not uninstall the Microsoft SQL Server Native Client
> component if you have SQL Server 2000 components installed.")
> Thanks in advance for your time and help!
>