I did a search for error '800a0bb9'<BR>and most things say its to do with opening a connection...<BR><BR>BUT works fine on the test server, but not on the live server ...

Take advantage of connection resiliency in EF Core to detect errors and retry commands and enable your ASP.NET Core application to overcome transient faults. A high-quality application must be stable, ...