provider: SQL Network Interfaces, error: 26

Question

I try to build the Database App in this Microsoft Walkthrough:(Simple Object Model and Query (C#)

https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/walkthrough-querying-across-relationships-csharp?redirectedfrom=MSDN

In fact when I debug it it said: System.Data.SqlClient.SqlException: '在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: SQL Network Interfaces, error: 26 - 定位指定的服务器/实例时出错)' like this:

I try to add database on VS2019 and see the Troubleshooting section of Learning by Walkthroughs . but it still not works. I opened SQL Server(MSSQLSERVER), and also open TCP/IP and Names Pipes. I also make a rules to allow use 1433 on firewall.

I have no idea to solve this problem, any suggestions? Or I need to connectionString on App.config? Even if in LINQ to SQL? Is so here is my connectionString

and how to add it?

And I felt. Mircosoft docs missing some steps....

Answer 1

Your connection string should be as follows if using SQL-Server Express edition

Server=.\SQLEXPRESS;Database=NorthWind;Integrated Security=true

The connection string may be stored in app.config or if using .NET 5 in appsettings.json

{
"database": {
"DatabaseServer": ".\\SQLEXPRESS",
"Catalog": "NorthWind2020",
"IntegratedSecurity": "true",
"UsingLogging": "true"
},
"ConnectionStrings": {
"DevelopmentConnection": "Server=.\\SQLEXPRESS;Database=NorthWind2020;Integrated Security=true",
"ProductionConnection": "Server=.\\SQLEXPRESS;Database=NorthWind2020;Integrated Security=true"
},
"Environment": {
"Production": false
}
}

Now with that understood see my code samples, one uses Entity Framework Core (preferred) while the other uses a data provider. Both use the same connection string under ConnectionStrings -> DevelopmentConnection were Environment specifies prod or dev (yes both are the same but in a real app they would be different.

The database for the code sample is a modified version of the original NorthWind which I created in 2020 hence 2020 appended to the catalog name.

Here is the database script.

Answer 2

When you connect using Microsoft Management Studio, please type the port no 1433.

Try Telnet command for 1433 also. In cmd.exe, type this command to check whether port 1433 is on : Telnet IPaddress or PC name 1433 (eg: Telnet 192.168.1.160 1433).

If cmd shows black screen, the port is opening.

please turn on Telnet Client in Win10 using Windows features on or off in Control panel.