SQL 2005 need to change named instance back to default

I went through the upgrade process from SQL 2000 to 2005 and got an error during the database services portion so the upgrade supposedly rolled back. Once we fixed the error we were not allowed to re-run the setup (which the instructions told us to do) because the instance was already installed. We could not go back to the old version either as it in essence wasn't there. The only option we could come up with was to create a new instance. Now we have two instances and would like our new one to change to the default one. We have mission critical data that has to be accessed by Monday morning so any help is greatly appreciated.
biotecAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
you cannot change the name of a instance, or from/to default.
you have to reinstall sql server for that.
0
biotecAuthor Commented:
So how can you uninstall the old instance or do you have to uninstall the whole SQL 2005 install which then wipes out all your jobs and dts packages etc. etc.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you will need to backup all your databases, so you can restore them later in the new instance.
you do NOT need to uninstall an instance to install another one, note that you can happily install instances of different versions/editions side by side.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

biotecAuthor Commented:
One more question. I noticed that through add/remove programs that you can repair or remove and it gives you instance options. Is it possible to just remove one instance without affecting the other instance? Thanks
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Is it possible to just remove one instance without affecting the other instance? Thanks
yes, perfectly. each instance is a 100% distinct installation of sql server, and can be managed distinctly, which includes deinstallation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
biotecAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.