Switching default instances

  • Hi all. First post on here in years.

    I have a server with two SQL instances on it. The default instance (running SQL 2016) and a named instance (SERVER\MSSQLSERVER2019 - running SQL 2019

    I need to make the 2019 instance the default one.

    Can I simply change the TCP/IP port for the named instance to 1433 and change the port for the current default instance, then restart them both.

    Would that work?

    Or do I have to go down the route of uninstalling the default instance then changing the port for the named instance?

    Many thanks in advance

    Steve

    • This topic was modified 2 years, 6 months ago by  smw147.

    Regards

    Steve

  • Yes it will work.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply