Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I get the following error when trying to install on Umbraco Azure:
This is due to SQL Azure not supporting certain options such as padding and page locks.
The only fix is having the courier SQL script cleaned up to be compatible with SQL Azure.
For now one work around would be to migrate your database to a regular SQL server, perform the installation (having your Azure web app point to this db) and migrate back to SQL Azure afterwards.. A bit cumbersome if you're already in production though.
You can get the manual install files from here:
Open the zip file and in the sql folder you can find app.sql and create.sql
App.sql should run without problems, create.sql needs to be modified to fit azure sql standars.
When those 2 scripts have run, you should be able to just copy the flat files to your sites and have something running.
Consult the manual install docs to verify you do everything needed to install manually on azure
Incase anyone else is looking, you have to execute this script after you get the error during installation:
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UCUserSettings]') AND type in (N'U'))
CREATE TABLE [dbo].[UCUserSettings](
[User] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Key] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Value] [nvarchar](2500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_UCUserSettings] PRIMARY KEY CLUSTERED
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF)
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted