经典的ASP应用程序遇到的SQL Server＆QUOT;超时＆QUOT;和＆QUOT; SQL Server不存在或拒绝访问＆QUOT; [英] Classic ASP application experiencing SQL Server "Timeouts" and "SQL Server does not exist or access denied"
问题描述
我们已经现在看到这个问题了一会儿，我真的试图总结我的周围是什么导致了它的头。
We've been seeing this problem for a while now and I'm really trying to wrap my head around what's causing it.
一对夫妇的时候，每天我们将看到时期，其中网页开始扔[微软] [ODBC SQL Server驱动程序]超时已过期，那么不久之后页面开始扔[微软] [ODBC SQL Server驱动程序] [DBNETLIB ] SQL Server不存在或拒绝访问。
A couple of times a day we'll see periods where web pages start throwing "[Microsoft][ODBC SQL Server Driver]Timeout expired" then shortly afterward pages start throwing "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied."
我们有一个连接到该数据库服务器的许多不同的应用。 2500左右的并发连接处理它平均每秒平均10,000个事务。我们的大多数应用中不会有任何问题任何的问题似乎只在Web服务器上的情况发生。 （也许是涉及到连接池？）
We have many different applications that connect to this database server. It averages around 2500 concurrent connections processing on average 10,000 transactions per second. Most of our applications have no problems whatsoever, the problems seem only to happen on the web server. (Perhaps it's related to connection pooling?)
我不知道该怎么认为这问题。有问题的SQL服务器被大大制服为它做的工作，并配有每处理器授权。因此，我不认为我们正在寻找一个发牌/性能问题。
I'm not sure what to attribute this problem to. The SQL server in question is vastly overpowered for the work that it does, and is equipped with per-processor licensing. So I don't think we're looking at a licensing/performance issue.
我想也许有一个IP连接问题，所以我改变使用的IP地址的ConnectionString并进行了一些长时间运行坪。我得到0的数据包在Web服务器和数据库服务器之间的丢失。
I thought maybe there was an IP connectivity issue, so I changed the ConnectionString to use the IP address and ran some long-running pings. I got 0 packets lost between the Web server and the Database server.
在ASP连接字符串现在看起来是这样的：
The ASP connection string now looks like this:
Provider=MSDASQL; Driver={SQL Server}; Server=10.0.100.100; Database=DBName; UID=WebUserName; PWD=WebUserPassword; ConnectionTimeout=15; CommandTimeout=120;
用户使用的是SQL Server身份验证连接的非域用户。因此，我不认为这是一个领域相关的问题。我检查了SQL服务器的日志文件，并没有发现任何任何相应的事件。
The user is a non-domain user connecting using Sql Server authentication. So I don't think it's a domain-related issue. I've checked the SQL server log files and have found nothing whatsoever corresponding to the incidents.
我发现<一个href=\"http://stackoverflow.com/questions/378881/intermittent-sql-server-odbc-timeout-expired\">another计算器问题描述类似的行为，但没有解决。
I've found another stackoverflow question describing similar behavior, but without a resolution.
的详细信息：
- Web服务器：Windows 2003的标准SP2，IIS 6
- 数据库服务器：Microsoft SQL Server的9.0.4035
有没有人见过/解决此类问题？没有任何人有任何建议，我应该寻找下一个在哪里？
Has anyone seen/resolved this type issue? Does anyone have any suggestions as to where I should look next?
谢谢！
-Zorlack
修改
谁能告诉我最好的做法是什么经典的高负荷ASP执行SQL查询？难道我们要尝试利用连接池？
Can anyone tell me what the best practice is for performing sql queries in classic high-load asp? Do we want to try to leverage connection pooling?
在看code，相当多的是这样的：
In looking at the code, quite a lot looks like this:
Set objCn = Server.CreateObject("ADODB.Connection")
objCn.Open(Application("RoConnStr"))
'do some stuff
objCn.Close
Set objCn = Nothing
解决方案（每斯科特的建议）
本文描述，一个发球，我的问题。我所做的更改注册表，然后重新启动服务器。
This article described, to a tee, my problem. I made the registry change and then rebooted the server.
问题解决了！
推荐答案
是您的Web应用程序关闭和数据库连接的处理（设置为没有）？
Is your web app closing and disposing (set to nothing) of database connections?
此外，你有没有尝试使用SQLOLEDB，而不是ODBC？想不出任何理由，你为什么会在这里使用ODBC。
Also, have you tried using SQLOLEDB instead of ODBC? Can't think of any reason why you'd be using ODBC here.
这里是一个非常繁忙的传统的ASP应用我的连接字符串：
here's my connection string on a very busy classic asp app:
Dim strcConn
strConn = "Provider=SQLOLEDB; Data Source=someserver; Initial Catalog=somedb; User ID=someuserid; Password=somepassword"
修改
我碰到这个博客张贴。有趣的一种。
I came across this blog posting. Kind of interesting.
<一个href=\"http://www.ryanbutcher.com/2006/02/classic-asp-on-2003-server-with.html\">http://www.ryanbutcher.com/2006/02/classic-asp-on-2003-server-with.html
这篇关于经典的ASP应用程序遇到的SQL Server＆QUOT;超时＆QUOT;和＆QUOT; SQL Server不存在或拒绝访问＆QUOT;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
