Make Named instance look like a Default instance

Spread the love

Convert or make SQL Server Named instance look like a Default instance

Hi tech giants, today I have learn how to make a SQL server named instance look like a default instance. Recently I was trying to connect an application with SQL server database & here I faced the real trouble. I have two named instance installed in my machine and the application could not make connection via server IP. I tried to connect with [.\]or [localhost] but failed to connect. Here the application need to connect the database via localhost or TCP IP not by a host name of server name. As I have two instance installed in my machine, so IP & localhost will not work.


I start googling and found two article helpful to  me. here are the both links.


As per the both article we need to change the IPALL Dynamic port to default SQL server default port 1433. So we login to the server and open SQL Server Configuration Manager. Here we can see two named instances are running. One is SQL Server (SERVER19) & other one is SQL Server (TEST19).

After that, we need to go to >> SQL Server Network Configuration >> Protocols for [NAMED INSTANCE] >> TCP/IP >> TCP/IP Properties >> IP Addresses. Scroll down and find IPALL. Now change the dynamic ports to default SQL Server port 1433. Its done !!

After clicking apply we will get a popup to restart the SQL server service. Restart the SQL Server Instance.


The Named Instance will now look as a Default Instance and we can reach the SQL server by below listed mode –

  • Named Instance Name [Example: SANJAYLAPTOP\SERVER19]
  • localhost
  • Only with (.) or (.\)
  • IP with or without port [Example: or,1433]
  • Host name [Example: SANJAYLAPTOP]

In addition I change my second NAMED SERVER port 1434.

Now I can connect the second SQL server with IP and Port number.


Spread the love
Author: OTi
Meet OTi, the brains behind the popular tech blog "" OTi is an accomplished author, tech enthusiast, and an expert in SQL Server. With over a decade of experience in the tech industry, he has become a trusted voice in the world of database management. OTi's passion for technology began at a young age, and he has been tinkering with computers ever since. He graduated with a degree in Computer Science and has since worked for some of the biggest tech companies in the world. His experience has given him a deep understanding of how technology works and how it can be used to improve our lives.

Leave a Reply

Your email address will not be published. Required fields are marked *