SQL Server Performance Forum – Threads Archive

2000 to 2005 side by side upgrade

I created a sql server 2005 named instance on my current sql server 2000 production server. I completed the conversion and have turned off all of the old 2000 instance. My question is can I just go into add/remove programs and remove sql server 2000 or is there a chance that if I do this the new sql server 2005 instance will inadvertantly get messed up (shared files, directory structure, etc.)? I figure there should be no problem but I would appreciate a confirmation. Thanks,
Jeff

AFAIK that should not be a problem because you’ve installed side by side. Maybe if you have active DTS-packages that haven’t been upgraded yet, so are imported in ssis but run in native sql2000 dts mode, you may want to install the backward compat modules for dts (feature pack).

It should not cuase any problems as alzdba mentioned but you can leave your shared files instead of removing them… you will be prompted while running uninstallation process…. or You can leave your SQL 2000 installaion and disable the sql services….
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

As mentioned we haven’t uninstalled the SQL 2k instance on a production server and so far no issues. Ensure the SQL 2k Services are in disabled mode otherwise you would get a surprise in future when the server is restarted, it is better to keep them with local system account too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thanks everyone for the responses. Satya, one question. I did disable all of the SQL 2000 services but I was wondering what you meant by saying "it would be better to run under the local system account as well"? When I was running the 2000 instance before the upgrade I was running under a domain account. Now that they are disabled are you saying I should change the start up account anyway? If so, why? Thanks,
Jeff

[<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] Yes change the startup account to use local system than that domain account, just to addup extra layer of security to avoid any network interaction in case someone starts up by mistake or wantedly. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

Thanks

]]>