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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation of DOTNETNUKE problemsInstallation of DOTNETNUKE problems
Previous
 
Next
New Post
9/13/2006 5:52 AM
 

I have started an installation of DOTNETNUKE however I am having some problems in getting it up and running.

I sucessfully copied DOTNETNUKE over to C:\INetPub and created a virtual directory in IIS.

I'm not sure if default.aspx is specified as a Default Document for the Virtual Directory.  How do I check this ?

I created a SQL Server database named DotNetNuke

I tried specifying the default data provider setting in web.config ( <data defaultProvider="SqlDataProvider" > ) however I got the following error when i tried to browse it, I couldnt edit it: -

Error Installing DotNetNuke

Current Assembly Version: 04.03.04

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

How do I rectify the above error ?

 
New Post
9/13/2006 11:37 AM
 

OK, You ask a couple of things so here are some answers:

1) I would assume you have default.aspx setup of you would not get are far as you did

2) Application settings in IIS must be ok - because again you would not have gotten this far otherwise

3) You don't have to change the dataProvider, you need to configure the connection string.  In the web.config you will find 2 connection string and both need to be configured (normally you will find these somewhere near line 20 and line 30 of the web.config.

Now, there are two different ways to setup the connection string if you are using SQL 2k / 2k5 or SQL Express.  That is another topic totally.  I personally do not run SQL Express so I always use the good old "<add name="SiteSqlServer" connectionString="Server=ServerOrPCName;Database=DatabaseName;uid=User;pwd=Password;" providerName="System.Data.SqlClient" />" for my connection.


Best Regards,

Robert J Collins | Co-Founder & President

Netlogic Corporation

 
New Post
9/14/2006 5:39 AM
 

What is the line in web.config that I am meant to edit ? And what should I enter for the connection string ?

Its SQL 2005 Express that Im running here.  How do I set up the connection string with it ? Or where can I get information on how to do that ?

 
New Post
9/14/2006 10:34 AM
 
This is not the solution. I am two weeks in the same boat and can't get a straight answer regarding SQL Express.

But what I have found is that SQL Express puts the database in c:\program files\microsoft sql server\mssql.1\mssql\data\
and I've tried forcing that string in place of |DataDirectory|. I've also tried to copy/move the database to the app_data folder under the DotNetNuke folder where it seems to look for it by default, but it's locked and I can't seem to figure out how to unlock it.

So I have been hammering at the <add key> & <add name> strings for the last two weeks trying to get rid of the error.

I don't think any other lines need to be edited. But again, I've dug through all the posts here.

We'll see if this gets your post back up top and anyone who has it running with SQL Express can tell us what they did.

-fitz
 
New Post
9/14/2006 11:54 AM
 

You didn't look at the docs at all, did you?  The web.config file is the configuration file for DNN.  It sets the parameters for several things, but first and foremost, it defines the connection string to the database as well as where the database/data server location (it can be local or remote)  The format of the connection string depends on whether you use MS SQL 2000/2005 or MS SQL EXPRESS as a database - the connection string is different for them.  The connection string is located near the beginning of the web.config file.  You have to pick one (the one for SQL Express) and comment out the other.   It is also set in two locations - connection string section and the application string section - They are near each other.   You should also download the docs and look them over.


Shadow
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation of DOTNETNUKE problemsInstallation of DOTNETNUKE problems


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