"login failed for collectionuser" errors appear after migrating our Sitecore 10.1.1 databases from self-hosted SQL Server on VM to Azure SQL Database. The site itself is working, but anything connected to XConnect is not.
- Validated all Connection Strings worked in all three sites
- Created individual collectionuser users and used the same password for each.
EXEC [xdb_collection].[GrantLeastPrivilege] @UserName = '$(CollectionDbUserName)'on each shard
- Updated the ServerName and DatabaseName fields to match the new server and database names
- Recycled AppPools and Services
If I revert only the collection connectionString the errors stop, so I know that it is the connection to those databases is the problem, but of course, we want the databases in Azure.... Anyone have any recommendations?