I'm doing a fresh install of Umbraco 7.0.4. I have Visual Studio 2012 and I've loaded Umbraco through NuGet. I have SQL Express 2008 with a new database called umbraco and a new user called umbracouser. This user is the dbo of the umbraco database and has explicit permissions to INSERT data. The application directory for this site has full write access for the IIS_IUSRS user, so all directories are writable.

I'm running through the install process and it hangs at the database set up. I get this error message:

The database configuration failed with the following message: The INSERT permission was denied on the object 'umbracoNode', database 'waggintrain', schema 'dbo'. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

It seems that either umbracoNode table is being created but the process doesn't have INSERT permissions on this table, or the umbracoNode table creation is failing and this is why it can't write to it. The database connection seems to be working here. Anyone have s imilar experience?

I look in the UbracoTraceLog.txt file and find this:

2014-02-20 15:13:03,806 [10] INFO  Umbraco.Core.ApplicationContext - [Thread 7] CurrentVersion different from configStatus: '7.0.4',''
2014-02-20 15:13:03,806 [10] INFO  Umbraco.Web.UI.Install.InstallerRestService - [Thread 7] Running 'Install' service
2014-02-20 15:13:03,830 [10] INFO  Umbraco.Core.DatabaseContext - [Thread 7] Database configuration status: Started
2014-02-20 15:13:04,309 [10] INFO  Umbraco.Core.ApplicationContext - [Thread 7] CurrentVersion different from configStatus: '7.0.4',''
2014-02-20 15:13:04,311 [10] INFO  Umbraco.Core.Persistence.Database - [Thread 7] Initializing database schema creation
2014-02-20 15:13:04,419 [10] INFO  Umbraco.Core.Persistence.Database - [Thread 7] Create Table sql -1:
 CREATE TABLE [umbracoNode] ([id] INTEGER NOT NULL IDENTITY(1,1),
[trashed] BIT NOT NULL CONSTRAINT [DF_umbracoNode_trashed] DEFAULT ('0'),
[parentID] INTEGER NOT NULL,
[nodeUser] INTEGER NULL,
[level] INTEGER NOT NULL,
[path] NVARCHAR(150) NOT NULL,
[sortOrder] INTEGER NOT NULL,
[uniqueID] UniqueIdentifier NULL,
[text] NVARCHAR(255) NULL,
[nodeObjectType] UniqueIdentifier NULL,
[createDate] DATETIME NOT NULL CONSTRAINT [DF_umbracoNode_createDate] DEFAULT (getdate()))
2014-02-20 15:13:04,422 [10] INFO  Umbraco.Core.Persistence.Database - [Thread 7] Primary Key sql -1:
 ALTER TABLE [umbracoNode] ADD CONSTRAINT [PK_structure] PRIMARY KEY CLUSTERED ([id])
2014-02-20 15:13:04,426 [10] INFO  Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 7] Creating data in table umbracoNode
2014-02-20 15:13:04,532 [10] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 7]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266
   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco)
2014-02-20 15:13:04,538 [10] INFO  Umbraco.Core.DatabaseContext - [Thread 7] Database configuration failed with the following error and stack trace: The INSERT permission was denied on the object 'umbracoNode', database 'waggintrain', schema 'dbo'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266
   at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
   at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco)
   at Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation.CreateUmbracNodeData()
   at Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation.InitializeBaseData(String tableName)
   at Umbraco.Core.Persistence.PetaPocoExtensions.CreateTable(Database db, Boolean overwrite, Type modelType)
   at Umbraco.Core.Persistence.Migrations.Initial.DatabaseSchemaCreation.InitializeDatabaseSchema()
   at Umbraco.Core.Persistence.PetaPocoExtensions.CreateDatabaseSchemaDo(Database db)
   at Umbraco.Core.DatabaseContext.CreateDatabaseSchemaAndData()
2014-02-20 15:13:04,545 [10] INFO  Umbraco.Core.DatabaseContext - [Thread 7] The database schema validation produced the following summary: 
The following tables were found in the database, but are not in the current schema:
umbracoNode,cmsTemplate,cmsContent,cmsContentVersion,cmsDocument,cmsContentType,cmsDocumentType,cmsDataType,cmsDataTypePreValues,cmsDictionary,cmsLanguageText,umbracoLanguage,umbracoDomains,umbracoLog,cmsMacro,cmsMacroProperty,cmsMemberType,cmsMember,cmsMember2MemberGroup,cmsContentXml,cmsPreviewXml,cmsPropertyTypeGroup,cmsPropertyType,cmsPropertyData,umbracoRelationType,umbracoRelation,cmsStylesheet,cmsStylesheetProperty,cmsTags,cmsTagRelationship,umbracoUserLogins,umbracoUserType,umbracoUser,cmsTaskType,cmsTask,cmsContentType2ContentType,cmsContentTypeAllowedContentType,umbracoUser2app,umbracoUser2NodeNotify,umbracoUser2NodePermission,umbracoServer
 

Akito