“/DgCRM”应用程序中的服务器错误。
--------------------------------------------------------------------------------
Login failed for user 'Tester'. Reason: Not associated with a trusted SQL Server connection.
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: Login failed for user 'dgcrmer'. Reason: Not associated with a trusted SQL Server connection.
源错误:
行 40: sqlConnection = new SqlConnection(connectionString);
行 41: sqlCommand = new SqlCommand(strSql, sqlConnection);
行 42: sqlConnection.Open();
行 43: obj = sqlCommand.ExecuteScalar();
行 44: sqlConnection.Close();
源文件: d:DgCRMApp_CodeBaseBase.cs 行: 42
堆栈跟踪:
[SqlException (0x80131904): Login failed for user 'dgcrmer'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Insus.NET.Base.ExecuteScalar(String strSql) in d:DgCRMApp_CodeBaseBase.cs:42
Insus.NET.BusinessBase.ExecuteScalar(String strSql) in d:DgCRMApp_CodeBaseBusinessBase.cs:38
Insus.NET.SystemParameter.GetParameterValueByPk(String strId) in d:DgCRMApp_CodeBackSystemParameter.cs:41
Insus.NET.InsusBase.get_ApplicationName() in d:DgCRMApp_CodeBaseInsusBase.cs:62
Insus.NET.InsusBase.Head(HtmlControl htmlCtrl, String strPageTitle) in d:DgCRMApp_CodeBaseInsusBase.cs:35
Insus.NET.InsusBase.HeadContent(HtmlControl htmlCtrl, String strPageTitle) in d:DgCRMApp_CodeBaseInsusBase.cs:30
Index.Page_Load(Object sender, EventArgs e) in d:DgCRMIndex.aspx.cs:19
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.1434; ASP.NET 版本:2.0.50727.1434
--------------------------------------------------------------------------------
Login failed for user 'Tester'. Reason: Not associated with a trusted SQL Server connection.
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: Login failed for user 'dgcrmer'. Reason: Not associated with a trusted SQL Server connection.
源错误:
行 40: sqlConnection = new SqlConnection(connectionString);
行 41: sqlCommand = new SqlCommand(strSql, sqlConnection);
行 42: sqlConnection.Open();
行 43: obj = sqlCommand.ExecuteScalar();
行 44: sqlConnection.Close();
源文件: d:DgCRMApp_CodeBaseBase.cs 行: 42
堆栈跟踪:
[SqlException (0x80131904): Login failed for user 'dgcrmer'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Insus.NET.Base.ExecuteScalar(String strSql) in d:DgCRMApp_CodeBaseBase.cs:42
Insus.NET.BusinessBase.ExecuteScalar(String strSql) in d:DgCRMApp_CodeBaseBusinessBase.cs:38
Insus.NET.SystemParameter.GetParameterValueByPk(String strId) in d:DgCRMApp_CodeBackSystemParameter.cs:41
Insus.NET.InsusBase.get_ApplicationName() in d:DgCRMApp_CodeBaseInsusBase.cs:62
Insus.NET.InsusBase.Head(HtmlControl htmlCtrl, String strPageTitle) in d:DgCRMApp_CodeBaseInsusBase.cs:35
Insus.NET.InsusBase.HeadContent(HtmlControl htmlCtrl, String strPageTitle) in d:DgCRMApp_CodeBaseInsusBase.cs:30
Index.Page_Load(Object sender, EventArgs e) in d:DgCRMIndex.aspx.cs:19
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.1434; ASP.NET 版本:2.0.50727.1434
出现这错误,往往是没有把ms SqlServer的Security选项卡的Authentication的作出正确的选择:
而引致的错误.