Share via

SQL Server Default Instances

Veena Srinivas 251 Reputation points
2021-02-02T20:10:30.043+00:00

Hello,

If I have a standalone server currently running 2016 Developer Edition - Default Instance am I able to install 2017 Developer edition and have another default instance on the same box ?

Thanks,
V

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

Answer accepted by question author

Sean Gallardy - MSFT 1,901 Reputation points Microsoft Employee
2021-02-02T20:36:01.81+00:00

No, there can only be a single default instance.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
    2021-02-03T02:09:03.747+00:00

    Hi @Veena Srinivas ,

    As SeanGallardy mentioned, we can install many instances on the same box but we only can have one default instance. You can install named instances if you already have default instance. Please refer to Database Engine Instances for more details.

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.