c# - 连接数据库时c#中的constring错误

Question

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

问题是数据库属性将连接字符串数据源显示为“xyz\sqlexpress”..如果我输入相同的连接字符串，它会显示错误为“使用转义序列”(\)...如果我将连接字符串修改为仅“xyz”，那么它会给出上面给定的错误...所以请建议我一些解决方案...

“我已经允许远程连接”，这个实例名到底是什么？

Answer 1

您需要转义反斜杠字符:

如果在代码中构造连接字符串:

"DataSource=xyz\\sqlexpress"

在你的配置文件中:

"DataSource=xyz\sqlexpress"