SQL 2008 (Web Developer Membership System) - Could not find stored procedure.
-
Hello, I've been having this same problem for over 2 weeks now and have found dozens of sites claiming to solve this problem, but it hasn't worked for me. I've followed all steps in the documentation etc correctly. When I try to login to my site, or create a new user, I get 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. Please review the stack trace for more information about the error 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 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): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +378
System.Web.Security.SqlMembershipProvider.CheckSJust to confim, have you tried aspnet_regsql.exe from visual studio command line?
-
Just to confim, have you tried aspnet_regsql.exe from visual studio command line?
I have used it before but not in this case as I'm not sure of what to do with regards to this particular problem. The membership login/registration works perfectly on my local machine but it only fails with the above error when it's uploaded to the server. Would doing something in aspnet_regsql.exe fix this issue?
-
I have used it before but not in this case as I'm not sure of what to do with regards to this particular problem. The membership login/registration works perfectly on my local machine but it only fails with the above error when it's uploaded to the server. Would doing something in aspnet_regsql.exe fix this issue?
As it seems that your database does not have all items required to support membership related functionality, you can run aspnet_regsql from visual studio command prompt to fix all aspnet membership related items in database. This will also include any missing stored procedure in the database.
-
As it seems that your database does not have all items required to support membership related functionality, you can run aspnet_regsql from visual studio command prompt to fix all aspnet membership related items in database. This will also include any missing stored procedure in the database.
In Visual Web Developer Express 08, in the Solution Explorer pane, if I expand the ASPNETDB and click Procedures, it contains a stored procedure that the above error claims it cannot find. ... Could you kindly suggest which commands I'd need to use in aspnet_regsql.exe?
-
In Visual Web Developer Express 08, in the Solution Explorer pane, if I expand the ASPNETDB and click Procedures, it contains a stored procedure that the above error claims it cannot find. ... Could you kindly suggest which commands I'd need to use in aspnet_regsql.exe?
In case only this particular stored procedure is missing then you can use this one... CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion] @Feature nvarchar(128), @CompatibleSchemaVersion nvarchar(128) AS BEGIN IF (EXISTS( SELECT * FROM dbo.aspnet_SchemaVersions WHERE Feature = LOWER( @Feature ) AND CompatibleSchemaVersion = @CompatibleSchemaVersion )) RETURN 0 RETURN 1 END
-
In Visual Web Developer Express 08, in the Solution Explorer pane, if I expand the ASPNETDB and click Procedures, it contains a stored procedure that the above error claims it cannot find. ... Could you kindly suggest which commands I'd need to use in aspnet_regsql.exe?
If you want to do this using apnet_regsql.exe, use the following steps: 1. Open visual studio command prompt 2. type aspnet_regsql and press enter 3. Click next on the window just appeared 4. select "configure sql server for application services", click on next 5. enter server name, username & password 6. choose databse from drop down 7. click on NEXT & NEXT This will repair your database.
-
If you want to do this using apnet_regsql.exe, use the following steps: 1. Open visual studio command prompt 2. type aspnet_regsql and press enter 3. Click next on the window just appeared 4. select "configure sql server for application services", click on next 5. enter server name, username & password 6. choose databse from drop down 7. click on NEXT & NEXT This will repair your database.
-
Thank you for your help and the code. It appears that there is no Command Prompt in Visual Web Developer Express 08. Can I just use the MS-DOS Command Prompt?
Try this one http://forums.asp.net/p/1196481/3303966.aspx#3303966[^]
-
Just to confim, have you tried aspnet_regsql.exe from visual studio command line?
-
My Pleasure :) Hope you have solved the issue.
-
My Pleasure :) Hope you have solved the issue.