Last post Feb 10, 2012 10:53 AM by rahulvom
Feb 10, 2012 03:35 AM|rahulvom|LINK
Hi Guys , I have this problem occuring everytime I start a new website.
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'D:\RAHUL\VISUAL STUDIO 2008\ASPPROJECT_DIARY\APP_DATA\ASPNETDB_TMP.MDF' because it already exists. Change the file path or the file name, and retry the operation. Creating the ASPNETDB_bc56ae5f8e52499aa3615589233b25d8 database...
I managed to solve this my renaming ASPNETDB_TMP.MDF file to ASPNETDB.MDF , then I get this new error when Security>Enable Roles > Create or Manage Roles.
The 'System.Web.Security.SqlRoleProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. at System.Web.Administration.WebAdminPage.CallWebAdminHelperMethod(Boolean isMembership, String methodName, Object parameters, Type paramTypes) at ASP.security_roles_manageallroles_aspx.BindGrid() at ASP.security_roles_manageallroles_aspx.Page_Load() at System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp, Object o) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Feb 10, 2012 10:53 AM|rahulvom|LINK
The Problem is with the permissions. Set Full Control to the Folder you are working on then it will pass through.