Here's the scenario: You make copy of a live website on your local, development computer, so you can test things out without fear of mucking up the live site.

However, when you attempt to log into the site, the browser redirects from your local URL (e.g. http://localhost:555555 to httpS://<ActualDomainName>).

When this happens, I think, "hey, I just need to dig around in the database's Settings table and find the value that forces it to SSL, and maybe also the SSL URL value as well). Then I search all over the Settings table and can't find it. Then I think, "hey, maybe this setting is in the web.config" (because there are some other platforms that do that), but can't find it there either.

Then I finally realize, "hey, this is probably a store-specific setting, so I wonder if it's in the Store table." And voila, it is!

So, if you need to temporarily view/change the settings that enforce SSL, as well as the URLs of the store, look in the Store table. Here's the T-SQL for your convenience:

SELECT Id, Name, Url, SslEnabled, SecureUrl, Hosts
FROM Store