应用程序无法连接到SQL Server [英] Application is not able to connect to sql server

问题描述

大家好，



在服务器上我创建了一个应用程序池，在这个池下我的4个应用程序正在运行。用户可以访问所有应用程序，所有不同的应用程序都连接到不同的数据库服务器。



用户浏览应用程序一段时间后，它与之无关数据库服务器，如果我尝试访问数据库服务器它没关系，我也尝试从localhost连接它也没关系。



如果我刷新了Web.Config然后现在应用程序现在能够连接到数据库服务器。



请帮助我在应用程序中没有打开连接时解决此问题。

Hello All,

On server i have created a application pool and under this pool my 4 application are running. User is able to access all the application and all different application are connected with different database server.

After some time when user is browse the application, it is not connected with the database server while if i try to access the database server it is OK and also i try to connect it from localhost it is also fine.

If i made refresh in Web.Config then now application is now able to connect to database server.

Please help me to solve this problem while no connection is open in application.

推荐答案

您好，

请确认您是否有任何存储过程或查询超出了web配置中提到的超时值。我早就遇到了类似的问题。

Hi,
Please identify do you have any stored procedures or queries which is taking more than time out value mentioned in web config. I had similar issue long back.

这篇关于应用程序无法连接到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！