Copied to clipboard

Flag this post as spam?

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


  • Robert Foster 459 posts 1820 karma points MVP 2x admin c-trib
    Aug 13, 2014 @ 06:36
    Robert Foster
    0

    Installation on Microsoft Azure hosted site - database script failed

    Hi Richard,

    We just tried to install SEO Checker on an Umbraco 7.1.4 site we're currently developing, and came across this error.  The hosting environment is a Web SQL database on MS Azure.  The error logged in the logfile included the Create script and ended in the following:

    System.Data.SqlClient.SqlException (0x80131904): 'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.SqlInternalConnection.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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
    at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters)
    at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
    ClientConnectionId:f655b8f1-4976-4509-866a-6fa44d3eae1f
    Error Number:40514,State:1,Class:16

     

    Any assistance appreciated - is it possible to take the create database script (that was dumped to the log file) and just edit it on the sql server management studio to get it to fit do you think?

    Thanks,

    Rob

  • Richard Soeteman 4035 posts 12842 karma points MVP
    Aug 13, 2014 @ 08:05
    Richard Soeteman
    0

    Hi Rob,

    Weird I thought every sql was Azure compatible now. Yes remove FileGroup from sql and run it Management studio.

    Hope this helps,

    Richard

  • Robert Foster 459 posts 1820 karma points MVP 2x admin c-trib
    Aug 13, 2014 @ 08:36
    Robert Foster
    0

    Removed

    ON[PRIMARY]

    from the script to fix it...

    Ta

Please Sign in or register to post replies

Write your reply to:

Draft