|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
removing SQL Server 2005 (multiple Visual Studio versions)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 Show quote "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! > > |
|||||||||||||||||||||||