SQL 2008 (Web Developer Membership System) - Could not find stored procedure.
-
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.