Nov 10, 2017
Nov 27, 2017
CMS Core
Closed, Fixed and tested
Steps to reproduce:
1. In SQL Server/LocalDB, create a new empty DB having Collation setting for case-sensitive - Collation setting name contains CS e.g. Latin1_General_100_CS_AI
2. Create a new site by using EPiServer.VsIntegration.Package.vsix.
3. Edit web.config to point the EPiServerDB connection string to the new DB at step #1.
4. Run Initialize-EPiDatabase cmdlet (or execute file \packages\EPiServer.CMS.Core.11.1.0*\tools\EPiServer.Cms.Core.sql)
Expected: EPiServerDB is created successfully.
Actual: Shows exception.
SQL ErrorsCreating [dbo].[netMappedIdentityForProvider]...
Msg 4104, Level 16, State 1, Procedure netMappedIdentityForProvider, Line 7227
The multi-part identifier "Mi.ExistingContentId" could not be bound.
Creating [dbo].[netMappedIdentityGetOrCreate]...
Msg 4104, Level 16, State 1, Procedure netMappedIdentityGetOrCreate, Line 7248
The multi-part identifier "Target.Provider" could not be bound.
Msg 4104, Level 16, State 1, Procedure netMappedIdentityGetOrCreate, Line 7248
The multi-part identifier "Target.ProviderUniqueId" could not be bound.
Creating [dbo].[netActivityLogEntrySave]...
Msg 4104, Level 16, State 1, Procedure netActivityLogEntrySave, Line 15128
The multi-part identifier "Target.To" could not be bound.
Msg 4104, Level 16, State 1, Procedure netActivityLogEntrySave, Line 15128
The multi-part identifier "Target.From" could not be bound.
Msg 4104, Level 16, State 1, Procedure netMappedIdentityForProvider, Line 7 [Batch Start Line 7220]
The multi-part identifier "Mi.ExistingContentId" could not be bound.