No tech from this decade then?

All jokes aside,

XP out of support

2012 out of support

SQL Native client (all versions) out of support

You shouldn't be running stuff on these platforms any more. ...

Option1 - Upgrade all your drivers to MSOLEDBSQL (or another driver which supports MSF) and use "MultiSubnetFailover=True" in your connection strings

Option 2 - you could set "RegisterAllProvidersIP" to false to only...

No you would need to use a linked server as it needs to resolve the read-write replica which could be any node.

If it was a select then that's a different...

Run a DBCC CHECKDB on the database, and see what it says is broken.

DBCC CHECKDB (UM_24_7) WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS, DATAPURITY, EXTENDED_LOGICAL_CHECKS

If nothing is returned then the...

Cool, maybe open a PR with the MSFT docs then to update it to...

Rip it all out and start again.

Reduce the size of the publications to manageable / groupable sizes, eg all tables relating to inventory, all tables relating to finance, that way...

You need to be a sysadmin to run that procedure

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-readerrorlog-transact-sql?view=sql-server-ver16#permissions

Permissions

Execute permissions for sp_readerrorlog are restricted to members of the sysadmin fixed server role.

Rip all the replication out and start it again from scratch.

3600 tables depending on your throughput may be an issue, you may want to look at splitting your publication into...

SQL needs to be running as an actual account, not NT SERVICE, so open SQL Config Manager and check what the services are running as.

Then if they are not a...

You need to access UNC paths.

Ensure that the services are actually running as domain accounts, then grant the domain service accounts/MSA's/gMSA's access to the UNC paths.

The two virtual service accounts...

Please post the full table definition, not just the 2 columns.

Have you read the documentation, or done a simple search on this topic, as doing a basic google search for "logshipping delay restore" yields a lot of results.

View the live data before creating the database.

You only view data after the live data view has been opened, so if you create the database before viewing live data you...

Not had to do that in a hot minute, but last time I did it was 90% painless.

As long as you have an appropriate driver to connect to MySQL you...

Are you able at all to post screenshots of the config pages, maybe a fresh pair of eyes can pinpoint the issue also?