Asp.Net Localhost正在访问远程SQL Sever2000，但IIS中的虚拟目录无法访问. [英] Asp.Net Localhost is accessing remote SQL Sever2000 but Virtual directory in IIS cant..??

问题描述

当我在VS2005中创建一个网站并运行它时，它正在端口上运行，并且正在连接到远程sql服务器.
但是，当我在IIS中创建虚拟目录并尝试运行我的网站时，它未连接到远程sql服务器.
有人可以帮我吗?

解决方案

检查可能是引起问题的原因. 检查您的网站的IIS设置.在您的网站属性中，确保选中"匿名访问"和"集成的Windows身份验证"复选框，并在匿名访问和身份验证控制"下选中"目录安全性"标签中的"部分.

来自此处 [ ^ ]

Minaxi，


首先，尝试在没有数据库连接的情况下运行简单的aspx页面.

与本地服务器连接(更改连接字符串)
比以后连接到远程服务器数据库.


看到错误并尝试将错误搜索到搜索范围内.
感谢2尝试2的所有人解决了我的问题.

When I create a website in VS2005 and run it, then it is running on the port and it is connecting to remote sql server.
But when I create Virtual directory in IIS and try to run my website it is not connecting to remote sql server.
Can anyone help me out?

解决方案

Check for which may be the cause.
Check IIS settings for your website. In your website properties, make sure that the checkboxes ''Anonymous access'' and ''Integrated Windows authentication'' are checked under ''Anonymous access and authentication control'' section in ''Directory Security'' tab.

from here[^]

Hi Minaxi,


First of all trying to run simple aspx page without database connection.

Than connect with with your local server (Change connection string)
Than after connect to remote server database.


See error and trying to search that error into search angin.

When i switched to SQL Server 2003, i faced no problem with the same code..

Thanks 2 all who tried 2 solve my problem.

这篇关于Asp.Net Localhost正在访问远程SQL Sever2000，但IIS中的虚拟目录无法访问.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！