[error] Login failed for user ''.

• Jon80

  SSCrazy

  Points: 2598

  More actions

  June 16, 2010 at 1:36 pm

  #233910

  I have an ASP.NET application, and, when loading the webpage that previously had a DataSource attached I get the following error.

  Server Error in '/SampleSite' Application.

  Login failed for user ''.

  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 ''.

  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 ''.]

  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009598

  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) +5023255

  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.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +95

  System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +206

  System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +827

  System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105

  System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +106

  System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +60

  System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +129

  System.Web.UI.WebControls.Login.AttemptLogin() +127

  System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101

  System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37

  System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +125

  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167

  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) +36

  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

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

  http://localhost/SampleSite/Account/Login.aspx

  web.config

  <?xml version="1.0"?>

  <!--

  For more information on how to configure your ASP.NET application, please visit

  http://go.microsoft.com/fwlink/?LinkId=169433

  -->

  <configuration>

  <connectionStrings>

  <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>

  <add name="sample_dbConnectionString" connectionString="Data Source='ARMANI\SQLEXPRESS';Integrated Security=True;Pooling=False;Initial Catalog='sample_db'; Integrated Security=SSPI" providerName="System.Data.SqlClient"/>

  </connectionStrings>

  <system.web>

  <compilation debug="true" targetFramework="4.0">

  <assemblies>

  <add assembly="System.IO.Log, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation>

  <authentication mode="Forms">

  <forms loginUrl="~/Account/Login.aspx" timeout="2880"/>

  </authentication>

  <membership>

  <providers>

  <clear/>

  <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/"/>

  </providers>

  </membership>

  <profile>

  <providers>

  <clear/>

  <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>

  </providers>

  </profile>

  <roleManager enabled="false">

  <providers>

  <clear/>

  <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/"/>

  <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/"/>

  </providers>

  </roleManager>

  </system.web>

  <system.webServer>

  <modules runAllManagedModulesForAllRequests="true"/>

  </system.webServer>

  </configuration>

  Windows authentication is successful through the Visual Studio 2010 UI (Server Explorer), the problem is probably the databound control (DropDownList).

  Intermittently 'Virtual Directory listing denied' (something like that) is also displayed, however, I understand that this is usually an IIS issue.

  It is cumbersome to troubleshoot the problem without having access to the SQL Server 2008 Management Studio, which does not seem to be available anywhere, isn't this available for trial versions?