Posted on: 8/13/2013 8:24:06 PM | Views : 241

I enabled RoleManager in my MVC app. It is using built in role provider I believe. Locally, the app works fine. It blocks user who I restrict. And these are the db files created under Web\App_data\ASPNETDB.mdf and Web\App_data\aspnetdb_log.ldf.
But as soon as I deployed this to QA environment, I am getting the following error
SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +388 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +688 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4403 Sys ...

Go to the complete details ...