Sql server无法通过asp.net在LAN上显示记录 [英] Sql server isn't able to display records on LAN through asp.net
问题描述
我在Intranet上运行ASP.NET应用程序。我正在使用SQL Server 2008来显示记录。我的系统充当主服务器。防火墙在所有系统上都关闭。
现在，当我的朋友在他的计算机上通过我的ip-address打开我的asp.net网站时，所有页面都会正确显示。但是从数据库中显示记录的页面会遇到问题。问题是没有显示记录。没有例外。我在我的SQL Server上使用Windows身份验证。
先谢谢。
I am running ASP.NET application on the intranet. I am using SQL Server 2008 to show records. My system acts the main server. Firewall is off on all systems.
Now when my friend,on his computer, opens my asp.net site via my ip-address then all the pages are displayed properly. But the pages where the records are to be shown from the database, they experience problems. The problem is that the records are not being displayed. No exception occurs. I am using windows authentication on my SQL Server.
Thanks in advance.
推荐答案
请阅读我对这个问题的评论。
要启用TCP / IP连接，请参阅：配置服务器以侦听特定TCP端口（SQL Server配置管理器） [ ^ ]
和......
我建议将防火墙置于开启模式，然后置于配置Windows防火墙以允许SQL Server访问 [ ^ ]
Please, read my comment to the question.
To enable TCP/IP connection, please see: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)[^]
And...
I'd suggest to put firewall in 'on' mode, then to Configure the Windows Firewall to Allow SQL Server Access[^]
这篇关于Sql server无法通过asp.net在LAN上显示记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
