You need to Register for free and Login to post a message in the forum.

Forum

Forums > Users Lounge > Everything Else
Subject: Can not login as host or admin after live database restoration
Prev Next
You are not authorized to post a reply.

Author Messages
wchung
Nuke Newbie
Nuke Newbie
Posts:6
29 Nov 2007 3:29 PM  
Hi, all.

What would be the problem if I can not login as host or admin after live hoster restored my locally generated database file?
There is no possibility that I lose the passwords for the host and admin because I use the same name and password combination all the time.
My localhost works just fine, but I have difficulty uploading to a live host; I guess the hoster do not seem to have DNN support or exprerience.

Does it have to do "setup permission" thing after database restore request?
I just asked them to restore my locally generated database backup file.

Thank you.

Kimchi
jncraig
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3750
29 Nov 2007 8:10 PM  
Are you having trouble logging into the DotNetNuke site, or are you having trouble logging into the database as a database user?

If everything is working fine, but you can't log in as host or admin to the DotNetNuke site, did you make any changes to your web.config file? Your web.config file must have the same machineKey setting as when you created the database. If they are different (compare the web.config file on localhost with the remote one) you must change your remote web.config to match the local one.
Joe Craig
DNN Creative Support
Subscribe to the website
wchung
Nuke Newbie
Nuke Newbie
Posts:6
29 Nov 2007 11:24 PM  
jncraig,

Thank you for your response. To describe what is happening with my hosting service, here is the sequence that I followed.

(1) Downloaded DNN 4.5.5 and followed wizard to install onto my localhost running MS SQL Server 2005 Express. It works fine in everything. The host and admin let me log in and just fine.
(2) I made a backup flie after I attached the App_Data\Database.mdf file. The backup default name is Database.mdf.BAK.
(3) After I changed local web.config I was able to login back to my localhost. That means I now direct the DNN to use the MS SQL Server 2005 Express. See my attachment at the end of this posting for my local web.config file's ConnectionString part.
(4) I created a datbase file for a hoster's remote MS SQL Server 2005. Of course I have created Login user for the server and assigned roles (asp_net.* and db_owner). Again the uid and pwd in the ConnectionString is appended at the end for your reference.
(5) After I uploaded the DNN 455 installation files and the backup file, I request a restoration service for my database backup file. They said "It is complete," which, I guess they mean they restored my backup file to my remote, hoster's SQL Server 2005.

Now, when I login to the hoster (http://www.woogonchung.net) the home page comes up. BUT, THE PROBLEM is that I can NOT login as host or admin. Again, trust me. I know my passwords for the host and admin account, because I use them all the time.

Below I have appened two web.config files; the first for the localhost version of my computer and the second is for the remote, live host version.

I will appreciate your help on this long-lasting trouble.

(Note: I blocked the password part of my web.config file with xxxxxxxxx .)




--------------- localhost, web.config ------------------


   
   
   
 
 
   
   
   


----------- remote, live host; web.config  ----------------------

 
   
   
          name="SiteSqlServer"
      connectionString="Server=67.36.254.131;Database=woogonchung_dnndb2;uid=dnndbuser2;pwd=xxxxxxxx;"/>
 
 
 
   
   
   

jncraig
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3750
30 Nov 2007 8:37 AM  
The web.config files didn't post correctly because of the < and > in all of the tags.

You need to check the machineKey setting in each of the two web.config files. They should be the same. Having the wrong machineKey setting is the most common reason that you can't log in. Do you get a message that the password is wrong when you try to login?

The fact that your site is running on the host system indicates that the connection strings are correct.
Joe Craig
DNN Creative Support
Subscribe to the website
wchung
Nuke Newbie
Nuke Newbie
Posts:6
30 Nov 2007 6:40 PM  
I made it. Thank you for your info. The machineKey values and their persistancy have been mentioned in the Video turorial series, though.

Kimchi
You are not authorized to post a reply.
Forums > Users Lounge > Everything Else > Can not login as host or admin after live database restoration


ActiveForums 3.7

Latest Forum Posts

RE: How to Create Module : by jncraig
I'd recommend the book on DotNetNuke module development by Mitchel Sellers, and also adefwebserver.c...
RE: Change Login Page by jncraig
If you want to add modules to the login page, first create on and add the login module. Then add ot...
RE: Background colour by jncraig
Use the Web Developers Toolbar to identify the class of the white area.
RE: [Server Error]This error can be caused by a virtual directory not being configured as an application in IIS. by arm
Posted By mnaoj on 04 Dec 2008 11:46 AMError 1 It is an error to use a section registered as allowDe...
How to Create Module : by hassangas2003
this first my question in aforum,i'm abeginer in DNN,I have web user control already used to old pro...
Background colour by petecarrick
Hi,Sorry if this is a real dumb question, I've been experimenting with the Vortex skin and I have ch...
RE: Horizontal menu vertical borders by petecarrick
That worked perfectly, thanks very much Lee.Pete
Change Login Page by edeakin
Hey guys it’s me again. Great work on session 46 keep up the great work! I want to be able to add m...
RE: Module Wrapper & Tab Aggregator?? by gbrown
Found the Ajax Module Wrapper from Gumbosoft. Bought it and tried it - it works inside of Tab Aggreg...
Module Wrapper & Tab Aggregator?? by gbrown
Has anybody tried to place a Module Wrapper module from ZLDNN inside a Tab Aggregator module from DN...
RE: SWF Tutorial Conversion by raymueller
Thanks and I will continue to research. Each of the applications pick up the introduction (~ 20-25 s...
RE: Please do review by leesykes
There are a couple of things that you could look at:Initial page load time of the sites was slow, t...
RE: Module Development - Settings Page by leesykes
thanks for letting us know the solution and if there's anything else we can help out with please let...
RE: SWF Tutorial Conversion by leesykes
not sure, its not something I have tried, the swf should convert, perhaps its worth googling around ...
RE: not been able to download videos by leesykes
Normal 0 unctuationKerning/> false false false oNotPromoteQF/> ...
RE: Styling the main menu by leesykes
When you add code to your skin.css file, make sure you press CTRL+F5 to reload the page and reload t...
RE: Horizontal menu vertical borders by leesykes
To find the id of the menu item, use the web developers toolbar for Firefox, go to information menu...
RE: Module Development - Settings Page by HMDevelopment
Hello Lee. No thanks -- I have still earned value from this site. I did quite a few 'video' tutor...
RE: Can I modify the Default Events module only for a Portal? by jncraig
If you create a skin for your site, it will apply only to your site.  Also, portal.css applies only ...
RE: How to prevent auser from multiple login. by jncraig
I'm not aware of a way to do that.
Free DotNetNuke Podcasts
RSS Feeds