Uploading site to web server - Installing DNN Platform

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

Home All Forums

Home

Getting Started

Installing DNN ...

Uploading site to web server

5/11/2011 7:05 PM

wanting2learn

Joined: 2/25/2011

Posts: 21

Uploading site to web server

INstalling on a hosted web server.

1. I have downloaded the Web INstall version of DotNetNuke
2. I have created a MSQL2008 Database using my web hosts control panel. The database is called 'dotnetnuke' the username is: 'username# and the password is: 'password'.
3. I notice that when my control panel creates this database the names turn to: db1128212_dotnetnuke and u1128212_username.

Question 1.
In my web.config file, do I use the 'db1128212_dotnetnuke' and 'u1128212_username' or simply 'dotnetnuke' and 'username'?

Question 2.
What do I use for the: 'Server=(local)'in the web.config file? What do I replace the 'local' with?

Question 3.
I am using the following connection strings:
"connectionStrings"
"add name="SiteSqlServer" connectionString="Server=(local);Database=dotnetnuke;uid=username;pwd=password;" providerName="System.Data.SqlClient"

"appSettings"
add key="SiteSqlServer" value="Server=(local);Database=dotnetnuke;uid=username;pwd=password;"

I have omitted some brackets due to formatting problems

And when I browse to my website I see the following error:
Server Error in '/' Application.
--------------------------------------------------------------------------------

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off".

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL.

Can someone point out what I am doing wrong please???

5/11/2011 7:27 PM

William Severance

www.wesnetdesigns.com
Joined: 2/18/2005

Posts: 3253

Re: Uploading site to web server

1. Use the 'db1128212_dotnetnuke' and 'u1128212_username'

2. Your hosting control panel, usually in the databases section or screen should give you the correct information for the server portion of the connection string. Most likely it will NOT be (localhost)

I'm assuming that you downloaded the DotNetNuke install packaged to your local PC and extracted the folders/files from the zip package before uploading them via FTP to your web site space at the hosting provider.

Also, make sure that the correct ASP.Net worker process account (IIS Identity Account) has been granted full permissions (including modify) on the root website folder and all child folders. Many hosts do not allow you to set the necessary permissions on the root folder and require you to contact them to have support set the necessary permissions for you. If you hosting provider is using a Plesk control panel, one problem I've seen on several hosts is that while the permissions may have been correct upon first accessing your control panel, the necessary permissions get removed as soon as you make any changes to the IIS settings and in particular should you add or modify the FTP user.

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

5/11/2011 7:36 PM

wanting2learn

Joined: 2/25/2011

Posts: 21

Re: Uploading site to web server

Thanks for the reply.

Yes I downloaded and extracted all the files locally before I uploaded them.

When I go to the database section of my control panel I click on my database and see the following:
Current connection string :
Provider=sqloledb;Data Source=pemmssql03.hosting.local,1433;Initial Catalog=db1128212_dotnetnuke;User Id=u1128212_username;Password=*****;

So should my connectionString="Server=(pemmssql03.hosting.local);???

re: If you hosting provider is using a Plesk control panel,
I see the follwing:
114442 mydomain.com Microsoft IIS 7.0 (Webspace 138126) Qmail Parallels Plesk Sitebuilder.

So how do I check if I have full permissions.
I must point out that if I place a normal index.html page into my directory then I can view it no problems.

Many Thanks

5/11/2011 7:48 PM

William Severance

www.wesnetdesigns.com
Joined: 2/18/2005

Posts: 3253

Re: Uploading site to web server

The DataSource and Server attributes can be used interchangably in a connection string. So, use the following:

Server=pemmssql03.hosting.local,1433;

Note that you need to include the port number (1433) preceeded by a comma.

You should be able to check permissions in the hosting control panels File Manager - look for a padlock icon beside the folder name. Click on that icon to see what permissions have been set for that folder. The hard part is to determine which is the correct account - its name likely will mention ASP.Net, IIS Identity or WP (for worker process account). Being able to view a html file correctly is not a test of proper ASP.Net permissions. When you start the DotNetNuke installer wizard it should do a permissions check for you but I've seen the permissions check be OK but still be lacking the necessary permissions.

5/11/2011 7:57 PM

wanting2learn

Joined: 2/25/2011

Posts: 21

Re: Uploading site to web server

I have checked the filemanager and the folder in question allows read and execute access to:
Application pool identity account,
Anonymous Web user and
Authenticated FTP user

So I don't think this is the problem.

Hmmmmmmmmmmmmmm

Page 1 of 2

Home

Getting Started

Installing DNN ...

Uploading site to web server

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)