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
0

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


  1. Open SQL Server Configuration Manager
  2. Click SQL Server Network Configuration
  3. Click Protocols for INSTANCENAME you want to make available
  4. Right-click TCP/IP and click Enabled
  5. Right-click TCP/IP and go to Properties
  6. Go to the IP Addresses tab
  7. Scroll down to the IPAll section
  8. Clear the field TCP Dynamic Ports (i.e. empty/blank)
  9. Set TCP Port to 1433
  10. Click Ok
  11. Go to SQL Server Services
  12. Right-click your SQL Server (INSTANCENAME) and click Restart
  • 1
    The opposite question may be useful as well but it deserves to be asked and answered separately. You can post a question together with the answer by ticking the "Answer your own question" checkbox at the bottom of the Ask a question page. Read more at Can I answer my own question? Also, please consider registering your account so that you don't accidentally lose ownership of your posts. – Andriy M Oct 18 at 9:43

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.