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 ...SQLExpress2005 Install on 4.03.05SQLExpress2005 Install on 4.03.05
Previous
 
Next
New Post
10/20/2006 2:46 AM
 
NTucker

Joined: 10/13/2006
Posts: 27

I am trying to install DNN 4.3.5 to my 2003 Server.  I am testing this on SQL 2005 Express. I read the documentation online and included in the install download.  I am not sure what to edit on the connection string.  I know I also have to edit the App part also I just need to understand the settings.

<!-- Connection String for SQL Server 2005 Express -->
    <add
      name="SiteSqlServer"
      connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
      providerName="System.Data.SqlClient" />

What is the name= for?  Do I put my Machine Name there or my database name? If I create a database on SQLExpress do I have to put it in App_Data folder?  Where do I set the username and passwords.

I am very new to this and I am sorry if my post has been answered somewhere else.  Any help would be much apperciated. Also I am not sure how to tell what my Instance name is.

Thanks for your help!  I am very excited to get this working!!

Neadom

Neadom Tucker New to the wide world of .NET... I could care less about PHP
 
New Post
10/20/2006 1:32 PM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

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

do not change the name "SiteSqlServer" it is used by DNN to recognize the appropriate connection.

If you use SQLExpress, use the .mdf syntax, if the install shall create the database for you, if you already created the db, use the 2000/2005 syntax. The instance name is set during sql server installation. it is usually either empty or /SQLExpress.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
10/20/2006 2:32 PM
 
NTucker

Joined: 10/13/2006
Posts: 27

Ok here is my connection String:

<!-- Connection String for SQL Server 2000/2005
    <add
      name="SiteSqlServer"
      connectionString="Server=TM-3\MSSQLSERVER;Database=optixwebnuke;uid=nukeweb;pwd=XXXXXX;"
      providerName="System.Data.SqlClient" />
   -->
  </connectionStrings>
  <appSettings>
   
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="Server=TM-3\MSSQLSERVER;Database=optixwebnuke;uid=nukeweb;pwd=XXXXXX;"/>
    -->

 

I have also tried:

<!-- Connection String for SQL Server 2000/2005
    <add
      name="SiteSqlServer"
      connectionString="Server=TM-3;Database=optixwebnuke;uid=nukeweb;pwd=XXXXXX;"
      providerName="System.Data.SqlClient" />
   -->
  </connectionStrings>
  <appSettings>
   
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="Server=TM-3;Database=optixwebnuke;uid=nukeweb;pwd=XXXXXX;"/>
    -->

I get this error now.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[NullReferenceException: Object reference not set to an instance of an object.]
   DotNetNuke.Common.Utilities.Config.GetConnectionString(String name) +47
   DotNetNuke.Common.Utilities.Config.GetConnectionString() +78
   DotNetNuke.Security.Membership.Data.SqlDataProvider..ctor() +82

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +103
   System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +261
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
   DotNetNuke.Framework.Reflection.CreateObject(String TypeName, String CacheKey, Boolean UseCache) +232
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) +571
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectNamespace, String ObjectAssemblyName) +17
   DotNetNuke.Security.Membership.Data.DataProvider.CreateProvider() +39
   DotNetNuke.Security.Membership.Data.DataProvider..cctor() +13

[TypeInitializationException: The type initializer for 'DotNetNuke.Security.Membership.Data.DataProvider' threw an exception.]
   DotNetNuke.Security.Membership.Data.DataProvider.Instance() +0
   DotNetNuke.Security.Membership.AspNetMembershipProvider..cctor() +5

[TypeInitializationException: The type initializer for 'DotNetNuke.Security.Membership.AspNetMembershipProvider' threw an exception.]

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +103
   System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +261
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
   DotNetNuke.Framework.Reflection.CreateObject(String TypeName, String CacheKey, Boolean UseCache) +232
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) +571
   DotNetNuke.Security.Membership.MembershipProvider.CreateProvider() +38
   DotNetNuke.Security.Membership.MembershipProvider..cctor() +13

[TypeInitializationException: The type initializer for 'DotNetNuke.Security.Membership.MembershipProvider' threw an exception.]
   DotNetNuke.Security.Membership.MembershipProvider.Instance() +0
   DotNetNuke.Entities.Users.UserOnlineController..cctor() +5

[TypeInitializationException: The type initializer for 'DotNetNuke.Entities.Users.UserOnlineController' threw an exception.]
   DotNetNuke.Entities.Users.UserOnlineController..ctor() +0
   DotNetNuke.HttpModules.UsersOnlineModule.OnAuthorizeRequest(Object s, EventArgs e) +107
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Then if I refresh my browser I get the following.

DotNetNuke Upgrade Error

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

The type initializer for 'DotNetNuke.Data.DataProvider' threw an exception.

So, I checked my Event Log and I get the following Entry

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  10/20/2006
Time:  6:26:19 AM
User:  N/A
Computer: TM-3
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/20/2006 6:26:19 AM
Event time (UTC): 10/20/2006 1:26:19 PM
Event ID: d3f074ee5e4446908eae1b364b66879b
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1044239046/Root-1-128058243792500000
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\Web\dotnetnuke\website\
    Machine name: TM-3
 
Process information:
    Process ID: 3512
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: TargetInvocationException
    Exception message: Exception has been thrown by the target of an invocation.
 
Request information:
    Request URL: http://64.85.3.125/Default.aspx
    Request path: /Default.aspx
    User host address: 64.85.3.125
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at DotNetNuke.Framework.Reflection.CreateObject(String TypeName, String CacheKey, Boolean UseCache)
   at DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache)
   at DotNetNuke.Data.DataProvider.CreateProvider()
   at DotNetNuke.Data.DataProvider..cctor()
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

So if I restart IIS 6 then I get the first error again:

Object reference not set to an instance of an object...

 

I have posted this in another post hoping to get some feedback on this setup.  I have done a lot of programming with ASP and SQL and I have not had these problems.

 

Thanks again for any help!

Neadom
Neadom Tucker New to the wide world of .NET... I could care less about PHP
 
New Post
10/20/2006 11:41 PM
 
David Martin

Joined: 10/18/2006
Posts: 37
The config file has entries with a key and a value.  The key allows the program to find info. it needs in the config file.  Eg. DO NOT change KEY values unless you want a DOA program!
 
New Post
10/21/2006 8:22 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
you need to have exactly one connection string active in both sections <connection strings> and <app settings>!
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQLExpress2005 Install on 4.03.05SQLExpress2005 Install on 4.03.05


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