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

4/30/2007 4:53 PM

Mark Gordon

Joined: 4/24/2007

Posts: 44

Noob Question

OK, I'm running the following on my desktop:
Windows XP Pro w/IIS
SQL Express

I went into SQL Server Management Studio Express and created a Database (first time I have ever used this product, but I think I did it correctly).

I unzipped the Install package into C:\DotNetNuke and created a virtual directory called "DotNetNuke" and made sure I was using ASP.NET 2 framework.

Here is what I need help on: The web.config connection string.   I have here:
   <add
   name="SiteSqlServer"
   connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|SWING-BLADE|DotNetNuke.mdf;"
      providerName="System.Data.SqlClient" />

What should I be putting for "AttachDBFilename? Also, Swing-Blade is my machine name (which ahs the SQL Express installed)...is this correct?

Thank you for your assistance. Mark Gordon

4/30/2007 5:49 PM

Mark Gordon

Joined: 4/24/2007

Posts: 44

Re: Noob Question

OK, I got this to somewhat run, but now my problem comes when I test the SQL Express Database connection. It comes back with the following error:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: -1
Message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I'm using the "sa" account with a password. Not sure what's wrong here?

4/30/2007 6:08 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Noob Question

Mark,

if you manually created the database and granted access, you need to use the SQL 2000/2005 connection string. please ensure, that both are changed identically.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

4/30/2007 6:21 PM

Mark Gordon

Joined: 4/24/2007

Posts: 44

Re: Noob Question

Thank you Leupold. I went ahead and commented out the SQL Express connection strings, but here is what I get now:

Parser Error Message: The configuration section cannot contain a CDATA or text element.

Source Error:

Line 34:   <appSettings>
Line 35:     <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules  --> 
Line 36:  <!--   <add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/> -->
Line 37:     
Line 38: Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules

Source File: C:\DotNetNuke\web.config Line: 36

4/30/2007 8:37 PM

Mark Gordon

Joined: 4/24/2007

Posts: 44

Re: Noob Question

Hi Leupold (or anyone that wants to help here!) :-)

I figured out what I was doing wrong in my web.config file. I am now receiving this error after the first screen in the install:

Server Error in '/DotNetNuke' Application.

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Any ideas? Thanks for helping! Mark Gordon

Page 1 of 2

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

Server Error in '/DotNetNuke' Application.

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

DNN Corp. (DotNetNuke)