Database could not be installed + umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'Pythagoras'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e)
Datatype could not be installed + System.NullReferenceException: Object reference not set to an instance of an object. at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e)
Updated /umbraco/config/create/ui.xml
Added dashboard to Contour application
Updated web.config to use correct asp.net ajax assemblies
Addded Formpicker macro control
Updated english language file with Contour keys
Umbraco 4.7.1
SQL Server 2008 R2
Other Packages installed: uComponents, 301 Url Tracker, FamFamFam
Contour installation error
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'Pythagoras'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e)
System.NullReferenceException: Object reference not set to an instance of an object. at Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e)
Is the database user the owner of the database? It looks to me like that user doesn't have the ability to create new tables.
-C
Comment author was deleted
You can download the create script on the project page so you could run the script on your db directly to fix the issue
is working on a reply...