Error installing Umbraco CMS 5 with SQL Server 2012
I
got the following error when installing Umbraco CMS 5 with SQL Server 2012 on
Windows Server 2008 R2, .Net 4.0, &IIS7 while Umbraco was setting up the database in SQL Server 2012
Installing Umbraco database
Please
wait while the Umbraco application is restarted.
Waiting for server response...
The
Umbraco database is being configured. This process populates your chosen
database with a blank Umbraco instance.
100%
Oops,
seems like the installation encountered some issues.
Here's an overview
of the exceptions, see the umbraco log for full details
ยทcould not load an entity:
[Umbraco.Framework.Persistence.RdbmsModel.AttributeSchemaDefinition#10000000-0000-0000-0000-000000000500][SQL:
SELECT attributes0_.NodeId as Id9_0_, attributes0_1_.DateCreated as
DateCrea2_9_0_, attributes0_1_.IsDisabled as IsDisabled9_0_, attributes0_.Alias
as Alias11_0_, attributes0_.Description as Descript3_11_0_, attributes0_.Name
as Name11_0_, attributes0_.SchemaType as SchemaType11_0_, attributes0_.XmlConfiguration
as XmlConfi6_11_0_ FROM dbo.[AttributeSchemaDefinition] attributes0_ inner join
dbo.Node attributes0_1_ on attributes0_.NodeId=attributes0_1_.Id WHERE
attributes0_.NodeId=?]
Any Help with this would be appreciated
Thanks :-)
Terry Clancy
Error installing Umbraco CMS 5 with SQL Server 2012
I got the following error when installing Umbraco CMS 5 with SQL Server 2012 on Windows Server 2008 R2, .Net 4.0, & IIS7 while Umbraco was setting up the database in SQL Server 2012
Installing Umbraco database
Please wait while the Umbraco application is restarted.
Waiting for server response...
The Umbraco database is being configured. This process populates your chosen database with a blank Umbraco instance.
100%
Oops, seems like the installation encountered some issues.
Here's an overview of the exceptions, see the umbraco log for full details
ยท could not load an entity: [Umbraco.Framework.Persistence.RdbmsModel.AttributeSchemaDefinition#10000000-0000-0000-0000-000000000500][SQL: SELECT attributes0_.NodeId as Id9_0_, attributes0_1_.DateCreated as DateCrea2_9_0_, attributes0_1_.IsDisabled as IsDisabled9_0_, attributes0_.Alias as Alias11_0_, attributes0_.Description as Descript3_11_0_, attributes0_.Name as Name11_0_, attributes0_.SchemaType as SchemaType11_0_, attributes0_.XmlConfiguration as XmlConfi6_11_0_ FROM dbo.[AttributeSchemaDefinition] attributes0_ inner join dbo.Node attributes0_1_ on attributes0_.NodeId=attributes0_1_.Id WHERE attributes0_.NodeId=?]
Any Help with this would be appreciated
Thanks :-)
Terry Clancy
OK - I fixed this myself - newby error :-) Here is what I did:
I fixed this by editing the SQL Server 2012 Database User as follows:
Owned schemas added all EXCEPT db-denydatareader and db-denydatawriter and guest
Membership added all EXCEPT db-denydatareader and db-denydatawriter
This problem is now fixed.
Terry Clancy
is working on a reply...