Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2005 need to change named instance back to default

Posted on 2008-11-08
6
Medium Priority
?
372 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:biotec
  • 3
  • 3
6 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22913041
you cannot change the name of a instance, or from/to default.
you have to reinstall sql server for that.
0
 

Author Comment

by:biotec
ID: 22913582
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22913746
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:biotec
ID: 22916735
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 22916921
>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
 

Author Closing Comment

by:biotec
ID: 31514678
Thanks
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question