Changing URL to HTTPS and enabling SSL breaks the site for admin

The website works perfectly, I even tried the exact same setup on a localhost version and it worked fine.
Essentially editing Store URL to HTTPS and enabling SSL(because the site does use SSL). Breaks the Admin portal.
However one of the plugins didn't work because of an HTTP request error. It would infinitely loop as it would not allow data to be transferred across HTTP.

I spoke to plugin dev and they suggested the SSL config was broken, but I could not find anything untoward there.

On my localhost version, I realized that the store URL in my DB was showing a different URL to what I had set on visual studio.
So I manually edited it in the DB to the right URL and enabled SSL.
And then suddenly it worked perfectly.
The plugin works, the Admin portal opens and the URL is correct.

Is there an issue where updating the URL of the store needs to be done first then enabling SSL?
Or does that URL not update if the page doesn't get back to the admin portal?

Any feedback would be helpful.

I do not think it matters. The database settings values are retrieved by the applications, so whether you set them directly or by the admin panel would not matter. Sounds like maybe a cache issue at the time you were making these edits and your system found the appropriate values. Are you using the same database for connecting a live site and your development environment?

No I have a different DB. The local one is just everything local on my pc.

I tried making the changes on Live and it just blocked me from entering the Admin portal.
Only with the store "EnableSSL" set to false can I even enter the Admin portal.(infinite redirect issue).

So I think it is something on the live website that is the issue for sure. Just not sure what it is.
I'm running the live one on a linux host box using IIS.

I must be missing something small I am sure.

Sounds like it. I am not all that versed in linux setups, so not going to be much help to you. Hope you find the issue. I know that I can't use force ssl on IIS Windows and through default nop ssl, when I do one counter acts against the other. Not implying it is that way for all, just in my setups I have this issue.