.NET Core 2 - Connection string with instance name and port number

Question

In my application I have a connection string in the config. This application created using .NET core 2.11 and SQL Server. This is the connection string:

Data Source=servername\instancename, portnumber;Initial Catalog=dbname;Persist Security Info=True;User ID=username;Password=password;

This string causes an error as shown here:

This error happens if I use instance name and port number in the string. If I remove either one, it is working. So, how do I make it work to used both instance name and port number in the connection string?

Have a look here for how to specify the port number: stackoverflow.com/a/5294741, I would avoid the space between the comma and the actual number. I'm not sure you can use a port number with an instance. — Robert Harvey
– Robert Harvey, Commented Mar 22, 2019 at 4:09

saf21 · Accepted Answer · 2019-04-09 02:09:57Z

1

Found the answer. Instance name will be use dynamic port, so I cannot use default port number (1433). Need to change the port number to used 1433 instead of the dynamic port.

answered Apr 9, 2019 at 2:09

saf21

8442 gold badges15 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

.NET Core 2 - Connection string with instance name and port number

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related