10

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?

9

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

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

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.

1

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

  • 3
    What does this add to the existing answers? – Erik Jan 8 '16 at 17:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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