You need to Register for free and Login to post a message in the forum.

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: Dnn - SQL 2k
Prev Next
You are not authorized to post a reply.

Author Messages
arthursc
DNN Creative Magazine Subscriber

Posts:20
04 Jan 2006 1:33 PM  

Hi Lee,

Get this error when running ctrl + F5 to build dnn;


            <pre>[NullReferenceException: Object reference not set to an instance of an object.]
            DotNetNuke.Common.Utilities.Config.GetConnectionString(String name) +49
            DotNetNuke.Data.SqlDataProvider..ctor() +126
            [TargetInvocationException: Exception has been thrown by the target of an invocation.]
            System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean&amp; canBeCached, RuntimeMethodHandle&amp; ctor, Boolean&amp; 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) +233
            DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) +571
            DotNetNuke.Data.DataProvider.CreateProvider() +39
            DotNetNuke.Data.DataProvider..cctor() +13
            [TypeInitializationException: The type initializer for 'DotNetNuke.Data.DataProvider' threw an exception.]
            <font style="BACKGROUND-COLOR: #ff0000">DotNetNuke.Common.Globals.GetUpgradeStatus() +331
            DotNetNuke.Common.Global.CheckVersion() +188
            DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) +322</font>
            </pre>
            <pre>(in red is this an issue?)</pre>
            <pre>IN Addition web.config is;</pre>
            <pre><font color="#0000ff" size="2">
            <p><<font color="#800000" size="2">connectionStrings</font><font color="#0000ff" size="2">>
            <p><!--<font color="#008000" size="2"> Connection String for SQL Server 2005 Express </font><font color="#0000ff" size="2">-->
            <p><!--<font color="#008000" size="2">add
            <p>name=&quot;SiteSqlServer&quot;</p>
            <p>connectionString=&quot;Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;&quot;</p>
            <p>providerName=&quot;System.Data.SqlClient&quot; /<font color="#0000ff" size="2">-->
            <p><!--<font color="#008000" size="2"> Connection String for SQL Server 2000/2005</font><font color="#0000ff" size="2">-->
            <p><<font color="#800000" size="2">add</font></p>
            </font></p>
            </font></p>
            </font></p>
            </font></p>
            </font></p>
            </font><font color="#0000ff" size="2">
            <p><font color="#ff0000" size="2">name</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">dnntriumph</font><font size="2">&quot;</font></p>
            </font><font color="#0000ff" size="2">
            <p><font color="#ff0000" size="2">connectionString</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">Server=(kess);Database=dnntriumph;uid=XXXXXXXX;pwd=XXXXXXX;</font><font size="2">&quot;</font></p>
            </font><font color="#0000ff" size="2">
            <p><font color="#ff0000" size="2">providerName</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">System.Data.SqlClient</font><font size="2">&quot;</font><font color="#0000ff" size="2"> />
            <p>&nbsp;</p>
            <p></<font color="#800000" size="2">connectionStrings</font><font color="#0000ff" size="2">>
            <p><<font color="#800000" size="2">appSettings</font><font color="#0000ff" size="2">>
            <p><!--<font color="#008000" size="2"> Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules </font><font color="#0000ff" size="2">-->
            <p><!--<font color="#008000" size="2"> add key=&quot;SiteSqlServer&quot; value=&quot;Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;&quot;/</font><font color="#0000ff" size="2">-->
            <p><!--<font color="#008000" size="2"> Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules</font><font color="#0000ff" size="2">-->
            <p><<font color="#800000" size="2">add</font><font color="#0000ff" size="2"> </font><font color="#ff0000" size="2">key</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">dnntriumph</font><font size="2">&quot;</font><font color="#0000ff" size="2"> </font><font color="#ff0000" size="2">value</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">Server=(kess);Database=dnntriumph;uid=XXXXXXXXX;pwd=XXXXXXXX;</font><font size="2">&quot;</font><font color="#0000ff" size="2">/></font></p>
            </font></p>
            </font></p>
            </font></p>
            </font></p>
            </font></p>
            </font></p>
            </font></pre>

Any Ideas....Thanks.
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3351
04 Jan 2006 1:56 PM  
Hello,

Have you added the database to your SQL server and added the Username
you have specified in your connection string to your SQL server database?

You also need to give the User of the database the correct permissions - ie. owner permissions.

Have any tables been added to the database?

If you receive errors when first installing I always wipe everything, all files & the database and then re-install
to ensure I get a completely clean installation. - So I would do this once you have worked out what the problem is.

Let us know how you get on and what the problem was.

If you think you have done all of this correctly try the asp.net forums in the Getting Started section
as there are many people on there that may have come across similar problems when installing for the first time.

Thanks,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > Dnn - SQL 2k


ActiveForums 3.7

Latest Forum Posts

Web.config Error by derpir
HelloI got this error, does this seem familiar to you? Can anyone say how to fix this error?Error 98...
No Access for me too by ristori
I suscribe for the magazine novembre 2008 13. I receive this ticket from Paypal : Prix de l...
How can I list our offices by country by bluehoops
Hi everyone!Apologies if this is a simple question, but it is driving me nuts.I run a small ISV and ...
RE: DNN Creative vs FireFoX V3 by DavidWSnow
It now looks like the error'ing extension is StumbleUpon and it effects FireFox on some, but not all...
Issue 39 Authentication by DavidWSnow
I was glad to see you address this topic. When LiveId was first added to DNN, I tried to implement i...
RE: (catalook) Itempane changes on product pages ?? by Vilaplana
Hi, I think the problem is been caused by your skin and not by Catalook itself.  In the main page, C...
Yahoo Answers by cdtguru
Hey, i was wondering if anyone knew of a module that would create a similar system to Yahoo Answers...
(catalook) Itempane changes on product pages ?? by Gaz35
Hi , hi , I don’t know if you can help me , here is the site in question http...
RE: Virtual Pc 2007 help by jeff@zina.com
You need to get the Virtual PC's network set up.  Might check the Virtual PC news group: http://www...
DNNCreative Just Keeps Getting Better by jeff@zina.com
Kudos on issue 39, the article on importing large quantities of data was both timely for me and spot...
RE: Videos by clippy
Hello from France My question is about the videos for beginners, and specially n° 3; I'm working...
skinning trouble by derpir
HelloI have uploaded a skin to my DNN-website, but I want to make som changes. I have made some chan...
RE: Column width in UDT by VickySwift
In case anyone else is looking for the answer to this, I have been able to add the headers back in b...
RE: search not working by jncraig
Did you either reindex the site to turn on the scheduled task to do it?
RE: Template Issue by jncraig
No, you need to install your custom modules before you use the template.
RE: error message in registration page by jncraig
I'm not sure that you can avoid them, short of rewriting the module.You might want to investigate Dy...
Template Issue by Bobbyjosephg
Hi,   Today I have come up with a problem with templates.I was successful in exporting a template an...
RE: search not working by sanju_k1421
I checked     host==>admin search  page   that is set both limits min //max  page     still i m n...
RE: error message in registration page by coder247
but how do I avoid the error messages provided by default in dnn?
RE: Style sheet does nothing by andorz
Oh. I was told to do that in my thread at the dotnetnuke.com forum. http://www.dotnetnuke.com/Commun...
AppTheory
RSS Feeds