January 03, 2006

CheckSchemaVersion Error

Error: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'
Error: Could not find stored procedure 'spGroupSelect'
Error: I enter the username and password and then click on submit in the Login page, I receive the Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

OK, wellcome, Be happy and don't worry ...
This is a security problem that comes from the connectionStrings in web.config
I know that your web.config file is OK but look at again ...
You must add Integrated Security=True;User Instance=True to your connectionString
If your connection string is the same as bellow
connectionString="data source='xxxxxx.com,1234';User ID='xxxxxx';Password=xxxxxx;database='xxxxxx'"
change it to
connectionString="data source='xxxxxx.com,1234';User ID='xxxxxx';Password=xxxxxx;database='xxxxxx';Integrated Security=True;User Instance=True"
Just this ...
This works for our ASP.NET 2.0 project on Microsoft Visual Studio 2005 Beta 2.0.
If you find another way, Don't be hesitate, paste it here

1 comment:

Anonymous said...

Thanks a lot ,

you save me so much time!!!