blocks|key|234761|text|我得到了这个错误，before...Make确保SQL+server服务已经启动。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|234762|如果不是这样，请将身份验证模式更改为服务器和窗口。|234763|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I got that error before...Make sure SQL server services are started

If that's not it, change the authentication mode to both server and windows.

blocks|key|1430812|text|这可能是由许多原因造成的，但首先要考虑的是Server本身的配置和设置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1430813|服务器上启用了命名管道吗？您可以通过服务器配置管理器(在server机器本身上)检查这一点。|1430814|用户是否安装在服务器上的连接字符串(如果使用SSPI，则为连接池用户)？|1430815|注：|offset|length|style|BOLD|1430816|我确实希望您所提供的连接字符串是您真正的连接字符串的编辑版本，因为它存在一些问题：|1430817|使用sa登录-您不应该这样做，因为现在任何SQL漏洞都可以造成任何它想要的损害。|unordered-list-item|CODE|1430818|调用sql+server+"webserver“-一个非常混乱的命名决定|1430819|当涉及到连接字符串时，请看connectionstrings.com+--它们包含了使用不同提供程序的许多数据库的有效连接字符串的良好列表。|1430820|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/^0|0|0|0|0|2|0|0|2|2|0|0|D|L|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|15|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|16|8|@$H|17|I|18|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1A|8|@$H|1B|I|1C|J|Q]]|9|@]|A|$]]|$1|R|3|S|5|P|7|1D|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1E|8|@]|9|@$H|1F|I|1G|1|1H]]|A|$]]|$1|V|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12]]]]

This can be caused by any number of reasons, but the first thing to look at is the configuration and setup of the SQL Server itself.

Are named pipes enabled on the server? You can check this through the server configuration manager (on the SQL Server machine itself).

Is the user on the connection string (or the connection pool user if you are using SSPI) setup on the server?

Note:

I do hope the connection string you put up is an edited version of your real one, as there are a couple of issues with it:

<ul>
<li>Using the <code>sa</code> login - you should never do that as now any SQL exploit can do any damage it wants</li>
<li>Calling a sql server "webserver" - a really confusion naming decision</li>
</ul>

When it comes to connection strings, look at <a href="http://www.connectionstrings.com/" rel="nofollow noreferrer">connectionstrings.com</a> - they hold a good list of valid connection strings to many databases using different providers.

blocks|key|1430855|text|可能是连接字符串问题。尝试将您的连接字符串与http://www.connectionstrings.com上的连接字符串进行比较，但也可能是远程连接或远程服务器(本例中的SQL服务器)不允许连接到SQL。检查是否允许远程连接并在数据库服务器上启用命名管道和/或TCP/IP协议。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1430856|但是，根据您所描述的场景，我认为拒绝连接的是数据库端(因为您已经有了一个可行的解决方案)。|1430857|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/^0|M|W|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

It could be a connectionstring problem. Try comparing your connectionstring to the connectionstrings at <a href="http://www.connectionstrings.com" rel="nofollow noreferrer">http://www.connectionstrings.com</a> but it could also be that the remote connection or the remote server (the webserver in this case) isn't allowed to connect to SQL.
Check if remote connections are allowed and named pipes and/or TCP/IP protocols are enabled on the database server. 

But, based on the scenario you've described, I'd say it's the database-end that's refusing the connection (since you've already had a working solution).

blocks|key|1785071|text|您的Server真的称为WEBSERVER+(DataSource="WEBSERVER")吗?？|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1785072|此外，我将永远不会在连接字符串中使用sa帐户-从不，句号。使用特定于应用程序的用户或其他东西，但是不在任何情况下都使用sa帐户。|BOLD|1785073|entityMap^0|C|9|N|M|0|I|2|1N|2|N|2|1D|1|0^^$0|@$1|2|3|4|5|6|7|K|8|@$9|L|A|M|B|C]|$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]|$9|U|A|V|B|H]|$9|W|A|X|B|H]]|D|@]|E|$]]|$1|I|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|J|$]]

Is your SQL Server really called <code>WEBSERVER</code> (<code>DataSource="WEBSERVER"</code>) ??

Also, I would never EVER use the <code>sa</code> account in a connection string - NEVER, period. Use an application specific user or something, but do not use the <code>sa</code> account under any circumstances.

We are upgrading from an environment where the development web server, the SQL Server 2005, and SQL Server data are all on the same machine, a Windows XP Machine. We are upgrading to having the web server on one Windows 2008 server, the SQL Server on a 2nd Windows 2008 Server, and to Server to a Windows 2008 server, nd the data on a SAN. 

Now we are getting the error message: 

<blockquote>
 A connection was succesfully established with the server, but then
 an error occured during the login
 process. (provider: named pipes
 provider, error 0, no process is on
 the other end of the pipe.)
</blockquote>

The network guy thinks it is a problem with the connection string: 

<pre><code>&lt;add name="CNString" 
 connectionString="Data Source=WEBSERVER;
 Initial Catalog=PCIdb;
 User ID=sa;Password=pass;"
 providerName="System.Data.SqlClient"/&gt;
</code></pre>

Can anyone help out here?

Not able to connect to the SQL Server data from asp.net app

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我们正在从开发web服务器、SQL server 2005和SQL Server数据都位于同一台计算机( Windows XP machine )的环境中进行升级。我们正在升级到一个Windows 2008服务器上的web服务器、第二个Windows 2008服务器上的SQL server和一个Windows 2008...

问无法从asp.net应用程序连接到Server数据
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法从asp.net应用程序连接到Server数据EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法从asp.net应用程序连接到Server数据
EN