DotNetNuke 7.2.0: Prevent "Getting Started Page" for SuperUsers

In DNN 7.2.0 has been added "Getting Started Page" for Super Users. It looks like this:

So, "Getting Started Page" appears on the next conditions:

1. Current User is SuperUser.
2. Current TabID is equal to the param "GettingStartedTabId" (for current Portal) from the "PortalSettings" table.
3. Setting "EnableGettingStartedPage" from the "HostSettings" table should be equal "True".

You can hide this message in few ways:

1. Just tick a checkbox "Don't show this again" at the bottom left corner. But this will hide "Getting Started Page" for current SuperUser only, and will show it for other SuperUsers.
2. Change "EnableGettingStartedPage" setting from the "HostSettings" table to "false". After this change, "Getting Started Page" will not be displayed for all SuperUsers.
3. If you like to change it for all future installations you plan to do, then you can edit "Install/DotNetNuke.install.config.resources" file in your installation package. In this file you can find "<EnableGettingStartedPage>True</EnableGettingStartedPage>", what is very easy to change to "False".

BTW: I have not found a way on how to change "EnableGettingStartedPage" setting from the "HostSettings" at the FrontEnd.

Backup MSSQL Database To External Path

It is very popular question from my clients. They have web access only to MS SQL database, but have to backup it to the external path. Ok, it can be done easy:

1. At the external server/computer make a folder, for example "C:\External_Backup".
2. Then go to the properties of this folder, tab "Sharing". Make public share with name "External_Backup" and add permissions for "Everyone" and "ANONYMOUS LOGON". Do not worry - its for few mins only, then we disable it.
3. Temporary disable Firewall.
4. Try to connect to this share from the Explore in this way "\\your_ip\External_Backup". You can see files and peform any actions in this folder.
5. In the web client of MSSQL database run query like this: BACKUP DATABASE your_db_name TO DISK = '\\your_ip\External_Backup\your_db_name.bak';
6. Enable Firewall and remove share from the public access.

DotNetNuke Not Uniq Emails

Sometimes clients ask to make registration at the site with uniq emails only. It somehow prevents to appear duplicates of the users. But sometimes site is live already and have a lot of registered users, then it needs to find all users with not uniq emails in DB and to fix. It is possible with query like this:

SELECT UserID, UserName, FirstName, LastName, Email, DisplayName

FROM {databaseOwner}{objectQualifier}Users

WHERE Email IN

(

SELECT Email

FROM {databaseOwner}{objectQualifier}Users

GROUP BY Email

HAVING COUNT(Email)>1

);

Hope this helps!

Self-Signed Certificate and Trusted Root

Sometimes we generate own SSL certificates, for example internal use: development or testing. It saves us time and money. But usually browsers or other applications does not accept Self-Signed certificates.

This problem can be fixed easy. All what we need is to add certificate to the Trusted Root Certication Authorities. Sure, you should have admin permissions to do these steps:

1) Open mmc console.

2) Add Snap-in for Certificates.

3) Open Trusted Root Certication Authorities/Certiciates in Certificates.

4) Right click and select Import, then select your .cer or .crt file and click Next.

5) Select to put it under Trusted Root Certification Authorities, click Next and Finish.

Sometimes it requires reboot, but probably does not.

Hope this helps!