Go Daddy - Database Access to fix Login Issue
Last Post 01/22/2008 4:11 AM by Lee Sykes. 3 Replies.
Author Messages
AlanJ
Nuker
Nuker
Posts:14


--
01/21/2008 4:03 AM
    I can no longer log into a site that I'm developing, and neither can anyone else.  On the plus side, no one is really coming to the site yet.  For details on the issue, please see this post.


    The site is hosted by a GoDaddy reseller.  If anyone can help me to understand how to get into the database to fix my problem, I will appreciate your thoughts.

    Thanks,
    Alan
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    01/21/2008 8:22 AM
    You now have a backup of the database, right?

    Joe Craig, Patapsco Research Group
    Complete DNN Support
    AlanJ
    Nuker
    Nuker
    Posts:14


    --
    01/21/2008 10:50 AM
    Yes.  I have a backup of the database which is locking me out.  Unfortunately, I do not have a backup of the database prior to the issue, or I would restore it.

    I have the backup on the following path: C:\Inetpub\wwwroot\lbc\_db_backups\let0735907220999.bak

    I have also FTPed down the the site and have this file: C:\Inetpub\wwwroot\lbc\1\App_Data\Database.mdf

    I have not set up any virtual directories, and I have not set up any Portal Aliases, and can not do this because I can't log in to the site to set a Portal Alias.

    I am not sure if Go Daddy has a SQL Server based tool that will allow me to explore the database.  I have SQL Server Express installed on my local computer.

    Thanks.
    Lee Sykes
    DNN Creative Staff
    Nuke Master VI
    Nuke Master VI
    Posts:4945


    --
    01/22/2008 4:11 AM
     if you follow the details in this tutorial How to backup a live hosted DotNetNuke website and restore it to a localhost installation it shows you how to restore a backup database file. You do not need to worry about the portal alias to attach the file into SQL server express. - once you have attached the database you can then access the tables within the database and the portal alias can be added directly into the tables.

    Thanks,
    Lee Sykes
    Site Administrator
    Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

    Twitter: www.twitter.com/DNNCreative

    Lee Sykes's Facebook Profile


    ---