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 II
Nuke Master II
Posts:2318
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 II
Nuke Master II
Posts:2318
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: EasyCGI help? by Dr Joe
I'll let you know how it works out. I think I opened up about 6 tickets with them so far. ...
RE: EasyCGI help? by derpir
Hi Joe amazing to say the least! I will change host to PowerDNN as soon as possible, seems to me t...
RE: EasyCGI help? by Dr Joe
Amazing - I'm going through this exact same thing with EasyCGI! I managed to successfully instal...
Running the local host installation after building the application by saintX
My localhost installation of DNN was running blameless. After I oppened the application with VWD it ...
RE: quick question by derpir
Hello Is it possible to buy two skins and combine them? for example put one skins visual attributes...
RE: Environment Variables by leesykes
Thanks for the info,
RE: How can i edit any module from front end by sanju_k1421
ok if i added an text html . now i want to fill into that have to log in ,but i want that an...
Module not working when logged off. by t.ramya85
Hi friends,I have created two modules which interact with each other and i have kept one module to b...
RE: Environment Variables by fandnet
There are many ways to use variables like what I was trying to use...But here is how I did it.DotNet...
RE: OpenForce '08 by mgordon
It was truly a great time.  I really feel this year was much better than last year.  I hope to ge th...
Environment Variables by fandnet
I am creating a simple module that registered users can use to send an email invitation to people wh...
RE: How can i edit any module from front end by leesykes
I'm not sure that I follow, could you provide an example?
RE: Development of modules by leesykes
Hello,Glad you find them useful, at the moment there are not any plans to go into Module Development...
RE: SQL Server 2008 Documents Module DotNetNuke by leesykes
Hello,Thanks for the tip. Yes both connection strings are in correctly and the user has full permiss...
RE: Now, portal creation problem by jncraig
Since you have other issues with installing modules, etc. I believe that you are correct that it's a...
RE: How do I display the current time by jncraig
The [CURRENTDATE] skin object has a DateFormat attribute. The examples give MMMM dd, yyyy as a typi...
RE: Now, portal creation problem by SupaHoopsa
Posted By jncraig on 18 Nov 2008 8:54 AMIf there are other errors related to the database, I would s...
RE: SQL Server 2008 Documents Module DotNetNuke by MobileNow
Make sure that both of the connection strings are the same in the web.config file. Also make sure t...
RE: Now, portal creation problem by jncraig
If there are other errors related to the database, I would start by looking there.  This could be so...
Un-installing SQL Server 2005 by leesykes
I'm in the process of un-installing SQL Server 2005 and while doing this it informs me that Full Tex...
DotNetNuke Modules
RSS Feeds