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 ...