ASP.NET - error logging into Web.config Could not find stored procedure "dbo.aspnet_CheckSchemaVersion"

Question

I am using forms authentication and gettnig the following error:

Server error in application "/".

Could not find stored procedure dbo.aspnet_CheckSchemaVersion. Description: An unhandled exception occurred during the execution of the current web request. View the stack trace for error information and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Source Error:

An unhandled exception was thrown during the execution of the current web request. Information about the origin and location of the exception can be identified using the exception stack trace below.

Stack trace:

[SqlException (0x80131904): Could not find stored procedure 'Dbo.aspnet_CheckSchemaVersion.]
System.Data.SqlClient.SqlConnection.OnError (SqlException exception, Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, Boolean breakConnection) +5009584
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.SqlCommand.FinishExecuteReader (SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, result DbAsyncResult) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery (DbAsyncResult result, String methodName, Boolean sendToPipe) +178
System.Data.SqlClient.SqlCommand.ExecuteNonQuery () +137
System.Web.Util.SecUtility.CheckSchemaVersion (ProviderBase provider, SqlConnection connection, String [], String version, Int32 & schemaVersionCheck) +392
System.Web.Security.SqlMembershipProvider.CheckSchemaVersion (SqlConnection connection) +84
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat (String username, Boolean updateLastLoginActivityDate, Int32 & status, String & password, Int32 & passwordFormat, String & passwordSalt, Int32 & failedPasswordAttemptCountTime & LastPortTimeLog & DateLogTentLog & DateLog & lastActivityDate) +827
System.Web.Security.SqlMembershipProvider.CheckPassword (String username, Password String, logical update LastLoginActivityDate, 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

here is my code in my web.config file:

<?xml version="1.0"?> <configuration> <connectionStrings> <add name="OleConnectionStringSource" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;User ID=PriceFinderUser;Password=******;Integrated Security=false" providerName="System.Data.SqlClient" /> <add name="OleConnectionStringTarget" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;User ID=PriceFinderUser;Password=******;Integrated Security=false" providerName="System.Data.OleDb;" /> <add name="PriceFinderConnectionString" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;Integrated Security=True" providerName="System.Data.SqlClient" /> <add name="PriceFinderConnectionString2" connectionString="Data Source=alg-sql01;Initial Catalog=PriceFinder;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web> <compilation debug="true" targetFramework="4.0" /> <authentication mode="Forms"> <forms loginUrl="~/default.aspx" timeout="2880" /> </authentication> <membership> <providers> <clear/> <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="OleConnectionStringSource" 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> 

How can I fix this error? Do you need to see any of the other files? thank you

Answer 1

Are tables and stored procedures created on your SQL server?

Take a look at this link and run aspnet_regsql.exe if you are using MS Sql-Server as a DBMS.

Answer 2

I resolved a similar error "dbo.aspnet_CheckSchemaVersion" in .NET 4 as a result of the missing Start Directory attribute in the connection string. Either a missing stored procedure or an invalid connection string causes a membership provider error.