I got all sorts of errors trying to set up security on an ASP.NET 2.0 web site using the ASP.NET Configuration web page, including “Could not find stored procedure 'dbo.aspnet.CheckSchemaVersion'“
This article http://msdn2.microsoft.com/en-us/library/x28wfk74.aspx was helpful.
Seems that the machine.config has an entry in connectionStrings for LocalSQLServer that points to an SQLExpress instance by default.
In the end all I had to do was run aspnet_regsql to create a database to store login details etc. (I called it ASPNETDB) then modify the connectionStrings, LocalSqlServer connection entry in the machine.config to point to this database.
Everything worked fine after that!
posted on Wednesday, January 11, 2006 11:23 PM