as per the subject, where is this? I locked up a portal by accident, having no ssl certificate, and i cannot find the location in the db to revert back this particular setting. thanks for any quick reply! drew.. 

Hi Drew,

Secure settings for individual tabs are configured via the IsSecure bit in the Tabs table.

The portal-specific settings are actually contained in the ModuleSettings table.  You can view a portal's SSL settings with the following query:

SELECT ModuleSettings.*
FROM ModuleSettings
INNER JOIN TabModules
 ON TabModules.ModuleID = ModuleSettings.ModuleID
INNER JOIN Tabs
 ON TabModules.TabID = Tabs.TabID
WHERE
 SettingName LIKE '%SSL%' AND
 Tabs.PortalId = @PortalID

Where @PortalID is the desired portal.

Hope this helps!

Brandon