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?
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:
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
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
Removed
from the script to fix it...
Ta
is working on a reply...