页面服务器连接另一台数据库服务器报错百分在线等方案

[uyou]

页面服务器连接另一台数据库服务器报错，奇怪的是用winform开发的应用程序就可以远程连接，且连接字符串（连接字符串保证无误）一样。

页面服务器：dotnet运行环境

数据库服务器：内网无ip地址，只有服务器名

报错：
Server Error in '/baseCode' Application.
--------------------------------------------------------------------------------

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
baseCode.Inc.ConnectData.R_ExecuteSql(SqlCommand com)
baseCode.Inc.ConnectData.NewBook_Count()
baseCode._default.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

[maotin]

SQL Server是不是用的混和模式登陆 ？

[hertcloud]

你再 仔细 检查
链接 字符串

链接 端口 也要一样

[rocy520]

链接 端口 也要一样

[yan63]

用sqlserver的帐户登陆还是windows的信任连接？
如果是后者可能是asp.net运行的帐户没有权限，使用sqlserver的帐户登陆即可

[uyou]

端口怎么写？
server＝servername:1433

[jxf654]

up

[honkerhero]

连接字符串，把安全验证的SSPI改为false

[cat_hsfz]

权限问题吧，因为WinForm可以用当前登录去连接SQL Server，而ASP.NET的当前登录权限很小。

[Eri]

支持楼上说法。
winform用的是你的登陆权限，asp.net则是另外一个权限。