Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mayfly Media 12 posts 177 karma points
    Nov 29, 2011 @ 14:46
    Mayfly Media
    0

    Contour installation error

    • 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

  • Chad Rosenthal 272 posts 474 karma points
    Nov 29, 2011 @ 17:30
    Chad Rosenthal
    0

    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

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Nov 30, 2011 @ 10:15
    Tim Geyssens
    1

    You can download the create script on the project page so you could run the script on your db directly to fix the issue

Please Sign in or register to post replies

Write your reply to:

Draft