The SQL Server encryption certificate that is generated in the Docker compose-init.ps1 scripts, is getting created with the current UTC timestamp. For servers located in timezones UTC−01:00 through UTC−12:00 (i.e. all USA locations), this means the cert is not yet valid, as its start date is in the future.
This results in a new Sitecore Docker environment that is broken and you cannot sign into, as the ID server is not able to contact the SQL server due to the failing certificate authentication.
Login attempt on a newly created Docker environment: -
Docker logs on the ID server showing the cert error: -
