Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...how do I find my database passwordhow do I find my database password
Previous
 
Next
New Post
8/16/2010 6:22 PM
 
I am moving a site to another host and need to set up the data base with a password. I can't find the data base password I used for the original set up and am sure I probably need to use the same one. How do I find the password. Is it on the site under admin or host?
Please advise.
Thanks
Richard
 
New Post
8/16/2010 6:48 PM
 
The databasename, userid, and password will be found in the < connectionStrings > section of the site's web.config file located in the root of the site's filesystem. It is not accessible from the portal or host settings or from the file manager. It is not necessary to keep the same database password. When moving the site don't forget to update BOTH connection strings with the new information. The second connection string is under the < appSettings > section of web.config and is the node with key="SiteSqlServer".

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
8/16/2010 7:30 PM
 
Thanks for the help again, I found this info but don't see a password unless it xxxx-

< connectionstrings />
      < add providerName="System.Data.SqlClient" connectionString="Server=aaaaaa.com;Database=bbbbb;uid=cccccc;pwd=xxxxx;" name="SiteSqlServer" />

If It doesn't matter I guss I don't have to worry about it but I am not sure about the other insturctions. I am moving the site contents to a new host at Godaddy and I have to install dotnetnuke on the site and then upload my files which are a "dotnetnuke" folder I believe. Possible you are saying I have to make some changes to my local files.

If you could clarify for me I would appreciate it , I think I am a bit confused.

Thanks, Ricahrd

EDIT BY MODERATOR: Replaced connection string value by xxxxx, etc.
 
New Post
8/16/2010 8:21 PM
 
Yes, that is the correct password value. As soon as I saw your reply I edited the actual values in the connection string you posted to replace them with xxxxx, etc. Never post actual connection string values, especially for a publically accessible database server in a forum such as this.

When moving a DotNetNuke installation from one hosting provider to another you will not be doing a new installation of DotNetNuke framework on the new host but rather:

1) If the site URL will be changing, add the new URL to the site's Portal Aliases.
2) Transferring ALL of the installation's files (including the web.config file) from the root folder on the old host to the website root folder on the new host.
3) Changing the two database connection strings in the web.config file to contain the correct connection information for the new host's SQL server.
4) Backing up the database located on the old host's SQL server and then restoring it to the new host's SQL server.
5) Repointing your site's domain registration name servers to the new host.

There are a number of steps to each of the above procedures and several potential issues you will have to work out along the way. I have never done an install on or migration to GoDaddy server but understand that DotNetNuke must be installed in a sub-folder of the public site folder and suspect that that may be an additional complication, particularly for any root relative file paths to images, etc. used in the existing site. I am also not sure what capabilities GoDaddy give you in their hosting control panel for setting filesystem permissions and restoring/directly accessing the SQL database.

You will also need to be certain that the new hosting account meets the minimum requirements for your current DotNetNuke version and later upgrades. For example, DotNetNuke versions 5.2.0 and above require ASP.Net 3.5 SP 1 and MS SQL Server 2005/2008 (standard or express).

Here are a few links to blog/forum posts and discussions relating to moving a DotNetNuke site that may be of help. Some are a bit old but the basic procedure is still the same:

http://www.dotnetnuke.com/Community/B...

http://www.mitchelsellers.com/blogs/a...

http://www.bestwebsites.co.nz/dotnetn...


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
8/16/2010 8:46 PM
 
Thanks,

 I will get going on this tomorrow when my head is a little fresher. Its sure seems like Monday.

Thanks for all your help,
Richard
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...how do I find my database passwordhow do I find my database password


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out