c# - 如何使用 ASP.NET 连接到 MSSQL Express

Question

我有一个应用程序 - 从 visual studio 2010 创建 - 我有一个专用服务器。服务器的操作系统是 windows server 2003。我的 Web 应用程序在 Visual Studio 的本地主机和我的 IIS 本地主机上运行。但是当我将它发布到服务器时，它给了我这个错误。

Login failed for user 'sa'. 


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: Login failed for user 'sa'.

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): Login failed for user 'sa'.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5066458
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
   System.Data.SqlClient.SqlConnection.Open() +125
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +123
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +319
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
   BerksanWebSite.Default2.Page_Load(Object sender, EventArgs e) in C:\Users\tekizer\documents\visual studio 2010\Projects\BerksanWebSite\BerksanWebSite\Default2.aspx.cs:94
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1022

这是我在 web.config 文件中的连接字符串标签

 <connectionStrings>
    <add name="websitesiConnectionString" connectionString="Server=xx.xxx.xxx.xxx; Database=websitesi;User ID=xxxx;Password=xxxxxx;"/>

  </connectionStrings>

我已经创建了一个类文件来调用 c# 代码的连接字符串。所以这是我在 C# 类中的 C# 连接变量。

private static string connectionstring_ = "Server=xx.xxx.xxx.xxx; Database=websitesi;User ID=xxxx;Password=xxxxxx;";

我从我的 C# 页面调用它来连接我在专用服务器上的数据库。

SqlConnection baglanti = new SqlConnection(berksanproje.connectionstring);
if(baglanti.State!=ConnectionState.Open)
{
baglanti.Open();
}

在我的专用服务器的 ASP.NET web 应用程序属性中ASP.NET 版本 4.0.30319当我单击编辑配置并单击常规选项卡时:

LocalSqlServer : Data Source=.\SQLEXPRESS;Initial Catalog=berksanwebsitesi;Integrated Security=True;

websitesiConnectionString : Server=xx.xxx.xxx.xxx; Database=websitesi;User ID=xxxx;Password=xxxxxx;

我可以通过 MSSQL 远程连接从我的计算机连接到我的数据库。但是我发布后无法连接到我的 aspx 页面。有什么方法可以将我的数据库连接到 asp.net

注意:我不会写任何地方来连接用户 sa。我不使用它。

Answer 1

我在我的专用服务器上安装了 Windows Server 2008。然后在使用 Management Studio 安装 .NET Framework 4.0 和 MSSQL Server 2008 R2 Express 后，我的系统可以正常工作。