But only the host name or. To connect but it can be connected,
When vs2019 connection and I used to can't retrieve the local database name, connection name or hostname \ instance name before when it can be retrieved, this problem for a long time, ever bosses to solve, thank you,
A current.net novices

CodePudding user response:

Could be connected, don't tangle,
Don't use the instance name, actually just default instance when installation,

Like mysql, there's no such usage, the instance name is IP + port,
Used in so-called instance, actually it is mapped to a port - different instance can not be together a port,
To sum up, the connection string instance, actually it is not a specification, not dispute with example is the "king",
So, focus your attention, to the IP and port, turns out to be more clear,
For example:
The Data Source=. \ sqlserver2014
="
Data Source=192.168.10.233, 1433

As long as it is with instance, certainly can use IP + port instead of,
But, in turn, can use the IP + port, can not use the instance name,

VS extract available connection string:
https://blog.csdn.net/yenange/article/details/77026214

SQL Server on a remote access Settings:
https://blog.csdn.net/yenange/article/details/50853083

CodePudding user response:

Thank you, I thing you can do this right now gets available connection string (VS), the fourth step of the article, the drop-down list out things

CodePudding user response:

refer to the second floor alex_andr response:

thank you, I thing you can do this right now gets available connection string (VS) the fourth step of the article, the drop-down list out things

I want to know is that, before connecting to the database or a hostname \ instance name, vs drop-down list can be normal out
But now reshipment database, can't use the hostname \ instance name, vs drop-down list is out
I'm thinking, the two will have the reason, thank the bosses