Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...Getting connection error during installGetting connection error during install
Previous
 
Next
New Post
3/2/2011 1:08 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
Having created the blank database using SSMSE and having set up SQL Authentication for that database you do not want to move the database file (mdf) into the site's App_Data folder. Leave the database file where it is!

Instead, when setting up the connection information in the DotNetNuke Install Wizard you must:

1. Set the Select Database radio button to "SQL Server 2005/2008 Database" NOT to "SQL Server 2005/2008 (Express) File". Even though you have SQL Express as your database server, in this case you will be treating it like the non-Express edition and not using the AttachDBFilename option.

2. With the above selection you will be able to enter the database name (DNN I'm guessing) that you created in SSMSE.

3. Make sure that Integrated Security is not checked

4. Enter the UserID (DNNUser) and Password

5. Make sure that run as db Owner is checked.

The benefit of having created a blank database as opposed to using the database file approach is to be able to easily examine and if necessary create additional database tables, proceedures, etc. from outside of DotNetNuke and easily create a database backup that will be necessary when migrating the site from its local install to a shared hosting provider or other live server.
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
3/2/2011 8:43 PM
 
Renoir


Joined: 2/23/2011
Posts: 7
It took longer to think about it, but the result was the same. Here is my current connection strings and the screen is below that.


    <!-- Connection String for SQL Server 2005/2008 -->
    <add name="SiteSqlServer" connectionString="Server=(local);Database=DNN;uid=DNNUser;pwd=dnnuser;" providerName="System.Data.SqlClient" />

    <!-- Connection String for SQL Server 2005/2008 - kept for backwards compatability - legacy modules -->
    <add key="SiteSqlServer" value="Server=(local);Database=DNN;uid=DNNUser;pwd=dnnuser;" />





Configure Database Connection

You can configure the database settings used by DotNetNuke on this page. If you are installing DotNetNuke in a "Hosting Account" your hosting provider should have provided you with the information.

There are two options for SQL Server 2005/2008. SQLServer 2005 and SQL Server 2008 support the use of Database Files. In most situations you should choose the Database option, but if you are using SQL Server 2005/2008 Express then you should use the File option.

Select Database:

Server: Enter the Name or IP Address of the computer where the Database is located. (if using Oracle enter the Data Source (SID))
Database: Enter the Database name
Integrated Security: Check this if you are using SQL Server's Integrated Security, which means you will be using your Windows account to access SQL Server. If you are using SQL Server Express then you will most likely need to check this option. If you have been given a UserId/Password to access your Database, leave this unchecked, and provide the UserId/Password combination.
User ID: Enter the UserID for the Database
Password: Enter the Password for the Database
Run as db Owner: Check this if you are running the database as Database Owner - if left unchecked you will be running as the User ID specified
Object Qualifier: Enter an optional "prefix" to use for all your database objects - this helps ensure that there are no object name clashes.
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: 2
Message:
 
 Page 3 of 3
Previous123 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Getting connection error during installGetting connection error during install


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