I have a site where SSL is enforced however I'm also having to go to each page and click the SSL check box.

If possible, is there a DB script that can be run that would prevent me from having to physically go and change every single page to click the "Secure" checkbox?


I tried the following:
Host > SQL to enable SSL for all pages of a website
UPDATE {databaseOwner}[{objectQualifier}Tabs] SET IsSecure = True WHERE PortalID = 0


But this gives me a syntax error.


Please Advise as soon as possible how i can Check all my pages as "IsSecure" without having to visit each page in via the admin.

Thanks..

Try that query like this (assuming that you have no object qualifier):

update tabs set issecure=1 where portalid=0

You can do this from the Host, SQL page.

You should test this out on a COPY of the database.

If you can connect to the database with SQL Server Management Studio, I would use that. You'll be able to see before and after versions of the table, and verify that you made the changes.

ALWAYS make sure you have a good backup copy of your database before trying something like that. Power tools are great, but ... you need to be careful and protect yourself and your data.

Thank You!


Yes, I agree when updating DBs it is ALWAYS good to Backup the DB first.....


Its too bad there is not a more automated single check box to perform tasks like this site wide...Do the latest versions of DNN have anything similar? Such as 7.x ?


I guess in theory, one could make their own module to perform such a task, but again.... "great caution should be taken"!


That also goes with the saying to all SQL DB Admins making mass updates to any SQL DataBase, "With Great Power, Comes Great Responsibility" or was that a movie?



Thank You Again!

I should have also said that {databaseOwner} and {objectQualifier} are shorthand for those items, but only if you need them. In this case, you presumable had no object qualifier and the DNN user is the database owner.