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
Kimchi
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
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
Joseph Craig
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5352
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
Kimchi
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
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;"/>
 
 
 
   
   
   

Joseph Craig
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5352
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
Kimchi
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
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
proarch123
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:4
02 Nov 2009 7:18 AM  
Hi,
Thanks alot it solved my problem.

Me also hosted my published files on intranet server. After hosting everything is woring fine except DNN login.
After copting the same machinekey which I used for development version it worked

Thanks,
ProArch.
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: Change Registration Redirect? by ollep
Probably still want to do it with Dynamic Forms now.My reason for changing (except from getting Aweb...
RE: Change Registration Redirect? by ollep
YES!http://www.dnncreative.com/Subscribe/tabid/81/Default.aspx
RE: Change Registration Redirect? by ollep
Yes I noticed that we where talking about 2 different Modules as soon as I dug into the tutorials.Ab...
RE: Change Registration Redirect? by leesykes
If you are check out the links that I have placed in there:http://www.dnncreative.com/Subscribe/tabi...
RE: Change Registration Redirect? by leesykes
Are you referring to when subscribing there is a link to register and after they register it sends t...
RE: Change Registration Redirect? by leesykes
The method I use on here for managing my email list is complicated and involves SQL queries, it is b...
Ecommerce module needed by vishalranaut
Infyecommerce is providing ecommerce packages for the clients to develop their ecommerce sites.They ...
RE: DS Dynamic Forms / AWeber by leesykes
If you are getting time out issues when installing I would use the auto install method by using FTP,...
RE: Change Registration Redirect? by ollep
Oooops Helps reading your responses before posting here Lee. I referred to Issue 40 / 41 and ...
DS Dynamic Forms / AWeber by ollep
Thanks for a great Tutorial Lee!  - As usual.(I still can't install the module in Firefox though, Fi...
while installing bulk emailer module in my website by agiline
Hi all,i have downloaded bulk e mailer trial version and when i am installing it in my website it wa...
RE: Creating Portals before setting the host by cyborama
Hello Joe, Just got done speaking with my hosting company in reguards to A records and host head...
RE: PayFlow Link by johnmurphy
Hi murphydolores, I am using iHost. iHost.Net supports PayFlow Link and its easy to configure. T...
RE: Background Music by cyborama
Hello Kyle I can't think of any modules that could do this though that doesn't mean they are not out...
RE: Creating Portals before setting the host by cyborama
Hello Joe thanks for the quick reply, If you read down my thread fully you will see I had already...
RE: Employee Absent Indicator by jncraig
I think that the biggest here is to define the workflow and to figure out who/how will maintain the ...
RE: Run exe/dll from DNN? by ollivogt
Thank you. I have a look at it....RegardsOliver
RE: DotNetNuke 5.3.0 Released by jncraig
Whoops! From Joe Brinkman: "With any software product you will occasionally have a release tha...
RE: Creating Portals before setting the host by jncraig
Whoops! Didn't quite finish. DNS, through A Records and other records is used to convert a domai...
RE: Creating Portals before setting the host by jncraig
NO! Don't delete and start over. "A Records" are part of DNS. Host Headers are part of IIS Co...
DotNetNuke Modules
RSS Feeds