August 01, 2007

Resolving DNN Login Issues With Login Tab Selection

Recently I have answered a number of questions regarding what to do when you accidentially change the login tab setting in "Portal Settings" on a DotNetNuke website to a tab that does not have a login module. This situation which is very easy to get yourself into is also one that is VERY easy to get out of as long as you are able to directly connect to SQL Server. If you are unable to connect directly to the SQL Server to run queries it will be a bit more involved to resolve the issue. In this posting I will discuss the very simple SQL Script needed to reset the LoginTabId value and get you back into your site.

Getting Ready

As I mentioned this process is very simple and you ONLY need 1 piece of information to be able to successfully execute the script that I will provide below. This piece of information is the "PortalId" of the portal you wish to modify. If you are unsure of your portal id you can easily locate it by running the following script to get a listing of portals.

SELECT portalId, portalName
FROM portals

Once you have your portal id we are ready to fix your site!

Performing the Fix

To fix your site we will simply clear the value for the Login Tab selection, this will remove any setting for a login page and the login link will function like a standard DNN installation will by injecting the login module for you. After you are back into your site you can re-configure the login tab selection to the proper tab. To perform this database change simply run the below script, be sure to modify the portalId value to be your proper portal id.

UPDATE portals
SET LoginTabId = NULL
PortalId 0

Now that we have updated the login tab value we will need to trigger an Application Restart due to the caching that is completed by DotNetNuke. The easiest method of doing this is to add a space to a NON critical portion of your web.config file and saving the change.

Once you have saved your web.config file you should now be able to browse to your site and login as normal! Please let me know if you have any questions or feedback regarding this tutorial.

tags: DNN, Tutorials
comments powered by Disqus

Content provided in this blog is provided "AS-IS" and the information should be used at your own discretion.  The thoughts and opinions expressed are the personal thoughts of Mitchel Sellers and do not reflect the opinions of his employer.

Content Copyright

Content in this blog is copyright protected.  Re-publishing on other websites is allowed as long as proper credit and backlink to the article is provided.  Any other re-publishing or distribution of this content is prohibited without written permission from Mitchel Sellers.