Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to convert default instance to named instance in SQL Server 2012?

By mistake I have chosen default instance option and installed. Now I have to change to named instance. How to change?

share|improve this question

Install the named instance, move the databases, agent jobs, etc over to it, then uninstall the now unused default instance.

share|improve this answer
3  
Good point migrating anything you've created. I assumed, bad habit, that he noticed the problem immediately after installation. – Steve Mangiameli Jan 7 at 3:51
1  
Instead of moving jobs ( if there are many)- just restore msdb using backup restore. – Kin Jan 7 at 13:24

The simple answer is you can't. If you aren't going to use the default instance, just uninstall it. You can install SQL Server again and create a named instance.

share|improve this answer

you can rename your instance but you can not change the named instance to default instance and vice versa.

share|improve this answer
1  
What does this add to the existing answers? – Erik Jan 8 at 17:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.