网络路径未找到错误消息

本文关键字:错误 消息 路径 网络 | 更新日期: 2023-09-27 18:04:51

我试图通过Filezilla部署我的网站。我在sql server 2012中创建了数据库,并将我的visual studio与sql server连接起来。当我在本地服务器上运行它时,它工作得很好,我可以很容易地登录和注销,但当我在web上部署它时,它在con.open()上显示此错误。请帮助。

描述:当前web请求执行过程中出现未处理的异常。请查看堆栈跟踪以获得有关错误及其在代码中的起源位置的更多信息。

异常详细信息:System.ComponentModel。Win32Exception:网络异常没有找到路径。

public partial class signinregistration : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=ISL-4;Initial Catalog=Cruisedb;Integrated Security=True");
        con.Open();
        DataTable dt = new DataTable();
        SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM [Login] WHERE Email = @email AND Password = @password", con);
        using (con)
        {
            sda.SelectCommand.Parameters.AddWithValue("@email", this.textboxemail.Text);
            sda.SelectCommand.Parameters.AddWithValue("@password", this.textboxpassword.Text);
            sda.Fill(dt);
            if (dt.Rows.Count == 0)
            {
                textboxemail.Text = "";
                textboxpassword.Text = "";
                Label3.Visible = true;
                return;
            }
            string txt = textboxemail.Text;
            Session["Email"] = txt;
            Response.Redirect("index.aspx");
        }
    }
}

源文件:第27行…第27行是con.open()。

堆栈跟踪:

[Win32Exception (0x80004005): The network path was not found]
[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to 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, Action`1 wrapCloseInAction)
+5341995
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546    
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover) +5353703    
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) +145    
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) +892
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) +311
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) +646    
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +278
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +38    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +732    
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +85
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1057    
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +78
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +196
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +146
System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +16
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +94
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +110
System.Data.SqlClient.SqlConnection.Open() +96    
signinregistration.Button1_Click1(Object sender, EventArgs e) in ''smb-whst-www02'whst_www02$'ff8b1b'user'fareshoppers.co.uk'web'signinregistration.aspx.cs:27 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9628462
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724
@MachineLearning
<?xml version="1.0"?>
    <configuration> 
        <connectionStrings> 
           <add name="ConnectionString" connectionString="Data Source=ISL-4;Initial Catalog=Cruisedb;Integrated Security=True" providerName="System.Data.SqlClient"/> 
       </connectionStrings> 
      <system.web> 
          <compilation debug="true" targetFramework="4.0">
          <assemblies>
              <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
          </assemblies>
     </compilation> 
    <customErrors mode="Off"/> 
</system.web> 
</configuration>

网络路径未找到错误消息

当你使用FileZilla部署你的网站时,它会将你所有的web应用程序文件复制到ftp文件夹中,但你的数据库不会被复制,因为它不在你的web项目路径中。您将找到您的数据库文件(。Mdf, .ldf等)在文件夹

C:'Program Files (x86)'Microsoft SQL Server'MSSQL.1'MSSQL'Data

但是你仍然不能复制你的数据库文件到服务器上并使用它们,因为数据库文件是由SQL server提供的,所以你的服务器(主机)上的SQL server应该知道数据库。

第一个要求是您的主机提供商应提供您MS SQL数据库。如果你目前的供应商不提供,那么你应该寻找一个单独的供应商,要么只提供你MS SQL数据库,要么托管MS SQL数据库(你计算这些选项的财务)

当你的主机提供商为你提供MS SQL数据库时,你必须登录到你的主机控制面板并导航到MS SQL选项(无论你的主机提供商的控制面板中可以调用什么)。在这里,您可以选择附加现有数据库文件或创建一个新数据库并运行查询。

如果您可以附加数据库

  1. 复制数据库的mdf和ldf(以及其他文件,如果有的话)到服务器和附加它们使用主机控制面板(您可能需要

如果您的主机服务提供商要求您创建新数据库

  1. 然后在那里创建一个新数据库
  2. 从您的本地服务器(在您的开发机器上)右键单击数据库,选择任务然后生成脚本生成当前数据库的脚本(去计算SO或Google上的选项)
  3. 将此脚本复制到您的主机控制面板的查询窗口中(无论该选项是否可用)
  4. 运行查询

对于上述两种情况,您将/可能必须根据需要更改连接字符串(基于数据库名称,您创建的用户名及其密码)

希望对你有帮助。