The installation for Sitecore 9.1.0 is stuck at step number 50. This is what I get in the System Event Logs as 3 separate errors.
Errors were encountered in the procedure 'dbo.__DeleteAllReportingData' during compilation of the object. Either the containment option of the database 'xp901_Reporting' was changed, or this object was present in model db and the user tried to create a new contained database.
Errors were encountered in the procedure 'dbo.ReduceMetricsTable' during compilation of the object. Either the containment option of the database 'xp901_Reporting' was changed, or this object was present in model db and the user tried to create a new contained database.
Errors were encountered in the procedure 'dbo.ReduceSegmentMetrics' during compilation of the object. Either the containment option of the database 'xp901_Reporting' was changed, or this object was present in model db and the user tried to create a new contained database.
Previously, I have installed Sitecore 9.0.1 and 9.0.2 on the same machine. Any pointers?
The PowerShell script is stuck at this point
[ShardingTool - Create]:[Path] C:\inetpub\wwwroot\xp910.xconnect\App_Data\collectiondeployment\Sitecore.Xdb.Collection.Database.SqlShardingDeploymentTool.exe
*** Welcome to Sitecore xDB Collection SQL Sharding Deployment Tool ***
Tool was run with the following configuration:
Operation: create
SQL server connection:
Server name: DESKTOP\SQLEXPRESS
User: sa
Integrated security: False
Connect Timeout: 15
Database edition: Basic
Shard map manager database name: xp901_Xdb.Collection.ShardMapManager
Shard map names: ContactIdShardMap, DeviceProfileIdShardMap, ContactIdentifiersIndexShardMap
Shard number: 2
Shard name prefix: xp910_Xdb.Collection.Shard
Shard name suffix:
Dacpac file path: C:\inetpub\wwwroot\xp901.xconnect\App_Data\collectiondeployment\Sitecore.Xdb.Collection.Database.Sql.dacpac
Creating database xp910_Xdb.Collection.ShardMapManager
Created Shard Map Manager