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 ...CanCan't install DNN 4.0.2 successfully.
Previous
 
Next
New Post
1/5/2006 11:42 PM
 
Ivan Chandra

Joined: 12/20/2005
Posts: 4

Hi folks. I am running winXP Pro with VS2005 and SQL Express 2005. I am assuming the SQL has been configured correctly. I followed the steps in configuring DNN 4.0.2 (this is the first time and the first version of DNN that I install), but I am frustrated with the error I have below:

This happens when I tried to load http://localhost/DotNetNuke_2/Website/Default.aspx

I have changed the web.config in naming, I changed 3 parts of "SiteSqlServer" to "DotNetNuke_2". <!-- Connection String for SQL Server 2005 Express -->

<add name="DotNetNuke_2" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />

<appSettings>

<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->

<add key="DotNetNuke_2" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" />

<providers>

<clear />

<add name="DNNSQLRoleProvider" type="DotNetNuke.Security.Role.DNNSQLRoleProvider, DotNetNuke.Provider.SQLRoleProvider" connectionStringName="DotNetNuke_2" applicationName="/" description="Stores and retrieves roles data from the local Microsoft SQL Server database" />

</providers>

Not sure if I mess up with the web.config but the errors I keep getting is shown below:

Please help. Thanks a lot for the suggestions/comments.

Server Error in '/DotNetNuke_2' Application.

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: 

Line 112:                'ASP.NET 2 version connection string (in <connectionstrings>)
Line 113:                'This will be for new v4.x installs or upgrades from v4.x
Line 114:                connectionString = System.Configuration.ConfigurationManager.ConnectionStrings(name).ConnectionString
Line 115:            End If
Line 116:

Source File: C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Shared\Config.vb    Line: 114

Stack Trace: 

[NullReferenceException: Object reference not set to an instance of an object.]
   DotNetNuke.Common.Utilities.Config.GetConnectionString(String name) in 
C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Shared\Config.vb:114
   DotNetNuke.Data.SqlDataProvider..ctor() in 
C:\Inetpub\wwwroot\DotNetNuke_2\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:58

[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
   System.Activator.CreateInstance(Type type) +6
   DotNetNuke.Framework.Reflection.CreateObject(String TypeName, String CacheKey, Boolean UseCache) 
in C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Shared\Reflection.vb:254
   DotNetNuke.Framework.Reflection.CreateObject
(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) in 
C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Shared\Reflection.vb:189
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, Boolean UseCache) 
in C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Shared\Reflection.vb:76
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType) in 
C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Shared\Reflection.vb:60
   DotNetNuke.Data.DataProvider.CreateProvider() in 
C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Providers\Data\DataProvider.vb:39
   DotNetNuke.Data.DataProvider..cctor() in C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Providers\Data\DataProvider.vb:34

[TypeInitializationException: The type initializer for 'DotNetNuke.Data.DataProvider' threw an exception.]
   DotNetNuke.Data.DataProvider.Instance() in C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Providers\Data\DataProvider.vb:45
   DotNetNuke.Entities.Portals.PortalSettings.GetProviderPath() in 
C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Portal\PortalSettings.vb:1138
   DotNetNuke.Common.Globals.GetUpgradeStatus() in C:\Inetpub\wwwroot\DotNetNuke_2\Library\Components\Shared\Globals.vb:914
   DotNetNuke.Common.Global.CheckVersion() +187
   DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) +298

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

 
New Post
1/6/2006 7:45 AM
 
Gavin Harriss

www.gavinharriss.com
Joined: 4/22/2004
Posts: 26
Hi Ivan,

I don't think you should be changing the actual "SiteSqlServer" to "DotNetNuke_2" but instead changing the connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" parts to point to the database you've created (edit the part I've highlighted in bold). I think there's 2 places this needs to be done in web.config off the top of my head.

If you've already created your database in SQL Server Express then you want your connection string to look something like:

"Server=COMPUTERNAME\SQLExpress;Database=DotNetNuke_2;User ID=YourUser;password=!Password;"

The bits in red you will change to match those of your database.

Hope this helps?

Gavin
Portfolio: www.gavinharriss.com


 
New Post
1/6/2006 10:45 AM
 
Charles Nurse


Charles Nurse's Avatar

Charles Nurse's Avatar

Joined: 2/9/2004
Posts: 3652
There are a few more places to change the name. 

In the Membership and Profile Provider sections, and also in the <dotnentnuke><data> sections.

 It is the last that is throwing an error, as it is expecting "SiteSqlServer" to be defined in the <connectionString> section, and you have changed it.

However,  changing the name is not neccessary, so it might be easier to change the ones you modified back
Charles Nurse
Chief Architect
Evoq Content Team Lead,
DNN Corp.

Want to contribute to the Platform project? - See here 		MVP (ASP.NET) and
ASPInsiders Member
View my profile on LinkedIn
 
New Post
1/6/2006 4:33 PM
 
Timothy Durkin

Joined: 1/4/2006
Posts: 11
As far as I can figure dude, you need to do one of the following:

1) Use Visual Studio/Adobe GoLive's replace all function and add all the files to the "search and replace" list. This will insure that you get ALL occurances of "SiteSqlServer" to "DotNetNuke_2"

2) Leave the web.config as is unless you NEED to change it because you renamed the database. I know it mentions confirming the web.config in the starter kit to make sure it says "DotNetNuke", but just skip that step entirely as it does not pertain to this version.
 
New Post
1/8/2006 11:07 PM
 
Ivan Chandra

Joined: 12/20/2005
Posts: 4

Hi Guys! I still can't access the http://localhost/DotNetNuke_2/ , when I try to, it displays "You aren't authorized to..". When I tried the http://localhost/DotNetNuke_2/Website/Default.aspx I got:

Server Error in '/DotNetNuke_2' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The entry 'SiteSqlServer' has already been added.

Source Error: 

Line 20:     <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />
Line 21:     <!-- Connection String for SQL Server 2000/2005 -->
Line 22:     <add
Line 23:       name="SiteSqlServer"
Line 24:       connectionString="Server=ACER-IVAN\SQLEXPRESS;Database=DotNetNuke;uid=ivan;pwd=;"

Source File: C:\Inetpub\wwwroot\DotNetNuke_2\Website\web.config    Line: 22

I am a little unsure about changing the connection string as mentioned. Do I need to comment out the "Connection String for SQL Server 2005 Express" but I am using the SQL Express. I know un-comment the "Connection String for SQL Server 2000/2005 which I am thinking it is not quite right. The part of the codes I changed is as below:

<connectionStrings>

<!-- 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" />

<!-- Connection String for SQL Server 2000/2005 -->

<add

name="SiteSqlServer"

connectionString="Server=ACER-IVAN\SQLEXPRESS;Database=DotNetNuke;uid=ivan;pwd=;"

providerName="System.Data.SqlClient" />

</connectionStrings>

Would anynone also show me how to create a correct user and password using SQL Server Express 2005. I use The Management Studio Express, I can add user, set the dbo_owner under "Database Role Membership". I can also add user, but I don't know how to set password in the SQL Server. I sign in with Windows Authentication mode. I left the "pwd=;" blank since not sure what password to include.

I found the dotnetnuke setup is not so easy and I wish there is a more details installation guide for DNN 4.0.2.

Thanks guys for helping me out.

 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...CanCan't install DNN 4.0.2 successfully.


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