VS2005发布网站,上传到服务器上出错!!SOS急救
出错信息:
Server Error in '/ ' Application.
--------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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 (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734995
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Connection.Open() +79
Connection.Exe_Proc(String Proc_Name) +15
Line_Route_All_Line.Band_Line() +40
Line_Route_All_Line.Page_Load(Object sender, EventArgs e) +21
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
--------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
Web.config的信息:
<?xml version= "1.0 "?>
<!--
注意: 除了手动编辑此文件以外，您还可以使用
Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的
“网站”-> “Asp.Net 配置”选项。
设置和注释的完整列表在
machine.config.comments 中，该文件通常位于
\Windows\Microsoft.Net\Framework\v2.x\Config 中
-->
<configuration>
<appSettings/>
<connectionStrings>
<add name= "peer1ConnectionString " connectionString= "Data Source=.;Initial Catalog=peer1_f;Integrated Security=True;user id=sa;password=123456 "
providerName= "System.Data.SqlClient " />
</connectionStrings>
<system.web>
<!--
设置 compilation debug= "true " 将调试符号插入
已编译的页面中。但由于这会
影响性能，因此只在开发过程中将此值
设置为 true。
-->
<compilation debug= "true " defaultLanguage= "c# "/>
<!--
通过 <authentication> 节可以配置 ASP.NET 使用的
安全身份验证模式，
以标识传入的用户。
-->
<authentication mode= "Windows "/>
<!--
如果在执行请求的过程中出现未处理的错误，
则通过 <customErrors> 节可以配置相应的处理步骤。具体说来，
开发人员通过该节可以配置
要显示的 html 错误页
以代替错误堆栈跟踪。
<customErrors mode= "RemoteOnly " defaultRedirect= "GenericErrorPage.htm ">
<error statusCode= "403 " redirect= "NoAccess.htm " />
<error statusCode= "404 " redirect= "FileNotFound.htm " />
</customErrors>
-->
<customErrors mode= "Off "/>
<pages validateRequest= "false " enableEventValidation= "false " > </pages>
<!-- 动态调试编译
设置 compilation debug= "true " 以启用 ASPX 调试。否则，将此值设置为
false 将提高此应用程序的运行时性能。
设置 compilation debug= "true " 以将调试符号(.pdb 信息)
插入到编译页中。因为这将创建执行起来
较慢的大文件，所以应该只在调试时将此值设置为 true，而在所有其他时候都设置为
false。有关更多信息，请参考有关
调试 ASP.NET 文件的文档。
-->
<trace
enabled= "false "
requestLimit= "10 "
pageOutput= "false "
traceMode= "SortByTime "
localOnly= "true "
/>
<!-- 会话状态设置
默认情况下，ASP.NET 使用 Cookie 来标识哪些请求属于特定的会话。
如果 Cookie 不可用，则可以通过将会话标识符添加到 URL 来跟踪会话。
若要禁用 Cookie，请设置 sessionState cookieless= "true "。
-->
</system.web>
</configuration>
服务器数据库信息:
数据库名称:peer1_f 密码:123456
连接出错,不知道怎么样去改正它....
请各位高手帮助........
[解决办法]
this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
[解决办法]
net2005 里面有个默认得数据库连接
[解决办法]
up
[解决办法]
看Exception Details
有可能是你的sql链接字符串不对
上传到服务器后,你的sql服务器跟iis服务器是同一台机器?
[解决办法]
SQL Server 外围应用配置器-> 远程连接，打开Tcp/Ip 默认的是本地连接, 要选中远程连接
