How to configure multiple instance of MS_SQL for web applications

Question

Hi Guys,

I am using SQL 2016 for my web applications till now and everything was working great, but because of some scenarios, I needed SQL 2019 for two web applications.

So, I installed SQL 2019 on the same server, so now I have SQL 2016 and SQL 2019.

But the problem is, both the new apps which are using SQL 2019 are not accessible from the internet. DO I need to make any specific changes?

One thing I noticed, in the SQL config manager the new SQL server network setting port numbers are empty, meaning they are not showing 1433 in from of ports.

Answer 1

If you have installed 2 SQL Server instances on one machine, then is at least one a "named instance" and you have to additional add the instance name to server name in your connection string,
e.g.
Server=MachineName\InstanceName;Database=...

SQL server network setting port numbers are empty

That means, the instance uses dynamically ports and the port can change on every restart. You can assign a fix port, see
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver15

Answer 2

Hi @satyam mehrotra ,

Did you specify the SQL server instance name in connection string as Olaf mentioned? Such as below;

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

> in the SQL config manager the new SQL server network setting port numbers are empty, meaning they are not showing 1433 in from of ports.

Agree with Olaf. You are using dynamically port. You can follow the MS document that Olaf offered to set the fixed port for named instance.In addition, TCP port 1433 is for SQL server default instance.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".