Hi,
I'm using Visual Studio 2005 Professional and SQL Server Standard. I ran the 'aspnet_regsql' tool to enable the application services for my ASP.NET project.
When using the WebPartManager control on my ASPX page, I encountered an error that tells that 'dbo.aspnet_CheckSchemaVersion' cannot be found. I guess this is pointing to the 'aspnetdb' database on my SQL Server. When I tried to navigate using Management Studio, I located the stored procedure, and verified it exists.
I also overwrite the <connectionStrings> localSqlServer on my web.config file from named instance of SqlExpress to my local SQL Server 2005.
Please help me to remedy this problem.
Thanks.
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'
abrewerton
Hi Benjamin,
I've got the same Problem. May you tell me how you expanded the connectionstring
greetings, blc
ReefDvrJim
I realize that this falls under the "check the obvious" category, but check the database to make sure that aspnet_CheckSchemaVersion actually does exist. I just spent some time troubleshooting this exact same problem because I "knew" that I had run aspnet_reqsql and that the membership tables and stored procs all existed. After reviewing the database, it turns out that none of the aspnet_* tables or stored procedures existed. So, I ran aspnet_regsql.exe and the error went away.
A__alex10
amagino
I fixed problem by the following way:
1. Using the command aspnet_regsql to update my database (TestDB - SQL Server 2k)
(After running this command you should check your database...)
2. Modify my web.config file:
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="data source=(local);Initial Catalog=TestDB;User Id=thanhlq;Password=thanhlq;" providerName="System.Data.SqlClient"/>
Thanks
fiaolle
Hi Benjamin,
I've got the same Problem too. May you tell me how I can do it
Thank you Richard