Desperate!!!! -- can't get DNN4 with sqlexpress2005 to work on winxp --- can't connect to DB!!!!!

HELP!!!!! HELP!!!!
I followed the install guide for DNN4 (install version)...but it doesn't work with SQL 2005 express on Win XP...i have tried everything!!

below is the error message and the connection strings...HELP!!!

 

Error Installing DotNetNuke
Current Assembly Version: 04.00.00
ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: Unable to open the physical file "C:\dotnetnuke\App_Data\dotnetnuke.mdf". Operating system error 5: "5(Access is denied.)". An attempt to attach an auto-named database for file C:\dotnetnuke\App_Data\dotnetnuke.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** Initialization Script *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ if exists (select * from dbo.sysobjects where id = object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin if '' <> '' begin EXECUTE sp_rename N'dbo.Version', N'Version', 'OBJECT' EXECUTE sp_rename N'PK_Version', N'PK_Version', 'OBJECT' EXECUTE sp_rename N'IX_Version', N'IX_Version', 'INDEX' ALTER TABLE dbo.Version ADD CONSTRAINT IX_Version UNIQUE NONCLUSTERED ( Major, Minor, Build ) ON [PRIMARY] end end else begin if not exists (select * from dbo.sysobjects where id = object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.Version ( [VersionId] [int] IDENTITY (1, 1) NOT NULL , [Major] [int] NOT NULL , [Minor] [int] NOT NULL , [Build] [int] NOT NULL ,
<connectionStrings>
  <!-- Connection String for SQL Server 2005 Express -->
  <add
    name="DotNetNuke"
    connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|dotnetnuke.mdf;"
    providerName="System.Data.SqlClient" />
  <!-- Connection String for SQL Server 2000/2005
    <add
      name="DotNetNuke"
      connectionString="Server=(local);Database=DotNetNuke;uid=dnnuser;pwd=password;"
      providerName="System.Data.SqlClient" />
   -->
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->
    <add key="DotNetNuke" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|dotnetnuke.mdf;"/>
    <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
    <add key="DotNetNuke" value="Server=(local);Database=DotNetNuke;uid=dnnuser;pwd=password;"/>
    -->
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <!--  Alternative Install Templates (included in package)
    <add key="InstallTemplate" value="Club.install.config" />
    <add key="InstallTemplate" value="Personal.install.config" />
    <add key="InstallTemplate" value="SmallBusiness.install.config" />
    -->
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
  </appSettings>

0
dlykins
12/7/2005 1:29:53 AM
asp.net.dotnetnuke-get-started 5241 articles. 0 followers. Follow

5 Replies
1150 Views

Similar Articles

[PageSpeed] 52
Get it on Google Play
Get it on Apple App Store

Check the NTFS permissions on the folder the MDB file is in.  Add MODIFY permissions for the ASP.NET user (ASPNET or NETWORK SERVICE) if they don't already exist.  You did give permissions for the user you connect as, correct?

Jeff


Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue.
0
jeff
12/7/2005 2:38:56 PM

Jeff -

Yes..i had already given ASPNET full control of the App_data folder.

As for the user, i login to the pc as DON and i gave it full control as well.

But in the webconfig, i setup a user in the sql 2005 express db called:  dnnuser.

does the winXP login and sql2005 user have to be the same???

0
dlykins
12/7/2005 11:46:56 PM
I posted an article with the steps of installing DNN 4.0 with SQL Express with screenshots. It has'nt been approved yet as soon as it does I'll send u the link.
Muhammad Fahad
Pakistan
0
mufahad149
12/8/2005 3:31:22 AM

No the users dont need to be the same...

Look at this one http://forums.asp.net/1135001/ShowPost.aspx and retry.


Muhammad Fahad
Pakistan
0
mufahad149
12/8/2005 4:31:12 AM

It works!!!!

I finally go this to work...(well sorta)...

Forget trying to do it with the Install version or the source version....I had to use the getting started version and followed these instructions (of sbwalker) to the tee:  http://forums.asp.net/1114393/ShowPost.aspx

I could never get it working otherwise......tried it on 4 different WinXP machines....

Only when I used the getting started version (DNN 4.0.1) did it get it to work.....

my configuration:

WinXP, DNN 4.0.1, sql 2005 express, iis 5.1, Visual Web Developer Express, DNN getting started 4.0.1

 

0
dlykins
12/8/2005 4:41:08 AM
Reply:

Similar Artilces:

When exiting a video playing with .wmv, you click the upper right "x" and you don't get back to the web homepage, you get stuck with a white, empty page. Explorer doesn't do that. It's an irritant f
Name: David Morgan Email: Dave_at_NewsCarsonCity.com Product: Firefox Summary: When exiting a video playing with .wmv, you click the upper right "x" and you don't get back to the web homepage, you get stuck with a white, empty page. Explorer doesn't do that. It's an irritant for those of us who want to use Mozilla, period. Comments: See summary. Browser Details: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ...

'Get It Now' button doesn't work
Have SM 1.1.11. I know that there are more recent versions. But 1.1.11 seems nice and stable. Nonetheless, a 'SeaMonkey Update Notification' regularly presents itself onscreen (usually after a re-boot). And so I have clicked on the 'Get It Now' button provided. Trouble is, nothing happens. (The computer is connected to the Internet, yes.) Comments, anyone? Thanks - Ken (in Oz) Ken wrote: > Have SM 1.1.11. I know that there are more recent versions. But 1.1.11 > seems nice and stable. Nonetheless, a 'SeaMonkey Update Notification' >...

An ASPNETDB DB-Procedure 'aspnet_Membership_createUser' doesn't get a @.......
This error comes suddenly since begin of year 2009 The envolved DB-Procedures 'aspnet_Membership_CreateUser' and  from this Predure called Procedures 'aspnet_Applications_CreateApplication' and  'aspnet_Users_CreateUser' seams to be syntactical not changed and quite OK. Why this error comes suddenly?  http://www.plbg.chPlanning of new IT Systems Hi ingenforum, Did you change the code in stored procedure? Did you change some configuration in database? From the error message, it seems to be caused by the output parameter. The original cod...

Messages don't always get sent if computer's date isn't right
I've found that if my computer's date is off by more than some unknown amount, when I send a message it doesn't always really get sent. Yet I don't get an error indication, and the message appears in my Sent folder right along with the rest of my sent messages. Anyone know how much my computer's date can differ from true time before this problem appears? Some of my messages to newsgroups had their dates off by two years, but still got posted. A few minutes ago, I sent two eamils to myself, one with my computer set to September 28, 2009 (one month error)...

new download has completely ruined my computer 's work ..I'm getting 1/2 pages.. slow or no loading. sometimes the mouse won't work.. I need to uninstall all of this.. please let me know how to do it!
Name: ann Email: Manhattan Product: Firefox Summary: new download has completely ruined my computer 's work ..I'm getting 1/2 pages.. slow or no loading. sometimes the mouse won't work.. I need to uninstall all of this.. please let me know how to do it!! Comments: what I just said!! Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.15) Gecko/2009101601 Firefox/3.0.15 GTB6 (.NET CLR 3.5.30729) From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to provide one...

superreview granted: [Bug 269318] TAB doesn't start from selection text after mouse click : [Attachment 166255] If element gets focused, move selection to focus if focus isn't already inside the sel
neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> has granted Aaron Leventhal <aaronleventhal@moonset.net>'s request for superreview: Bug 269318: TAB doesn't start from selection text after mouse click https://bugzilla.mozilla.org/show_bug.cgi?id=269318 Attachment 166255: If element gets focused, move selection to focus if focus isn't already inside the selection. mLastFocusedWith is no longer needed for making tab not move relative to selection after a mouse click https://bugzilla.mozilla.org/attachment.cgi?id=166255&action=edit ------- Addition...

superreview requested: [Bug 269318] TAB doesn't start from selection text after mouse click : [Attachment 166255] If element gets focused, move selection to focus if focus isn't already inside the s
Aaron Leventhal <aaronleventhal@moonset.net> has asked neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> for superreview: Bug 269318: TAB doesn't start from selection text after mouse click https://bugzilla.mozilla.org/show_bug.cgi?id=269318 Attachment 166255: If element gets focused, move selection to focus if focus isn't already inside the selection. mLastFocusedWith is no longer needed for making tab not move relative to selection after a mouse click https://bugzilla.mozilla.org/attachment.cgi?id=166255&action=edit ...

Hello Sir/Ma'm, why it isn't working as before, I'm not getting gmail ID on firefox
Name: Ram Babu Email: rambabu234sonuataoldotcodotuk Product: Firefox Summary: Hello Sir/Ma'm, why it isn't working as before, I'm not getting gmail ID on firefox Comments: Hello Sir/Ma'm, why it isn't working as before, I'm not getting gmail ID on firefox. Let me know why is it happening . . I'm waiting your urgent response, about this because I use to work on firefox browser, So hurryup, I need its very urgent thanks for favour Ram Babu Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox...

'do' won't 'do' if '/'
Greetings to All from Au, Have a NetWare Perl 5.8.4 and wanted to tweak File\Spec\NW.pm to try and standardise on '/' separators. If I run a test script (t/uni/lower.t) with an unmodified NW.pm, it calls t/uni/case.pl, that, in case.pl, (when the path separators are '\'), the $file is '..\lib\unicore\To\Lower.pl' and the following code portion works, with $simple getting a returned table: sub casetest { my ($base, $spec, $func) = @_; my $file = File::Spec->catfile(File::Spec->catdir(File::Spec->updir, "lib", &qu...

superreview granted: [Bug 448281] font-size sometimes gets calculated wrong : [Attachment 332497] patch 1: don't rebuild rule cascades if they're aren't currently any
Boris Zbarsky (todo: 200+ items) <bzbarsky@mit.edu> has granted David Baron [:dbaron] <dbaron@mozilla.com>'s request for superreview: Bug 448281: font-size sometimes gets calculated wrong https://bugzilla.mozilla.org/show_bug.cgi?id=448281 Attachment 332497: patch 1: don't rebuild rule cascades if they're aren't currently any https://bugzilla.mozilla.org/attachment.cgi?id=332497&action=edit ------- Additional Comments from Boris Zbarsky (todo: 200+ items) <bzbarsky@mit.edu> >+ // early (e.g., before whether we know if the quirk style sheet...

superreview requested: [Bug 448281] font-size sometimes gets calculated wrong : [Attachment 332497] patch 1: don't rebuild rule cascades if they're aren't currently any
David Baron [:dbaron] <dbaron@mozilla.com> has asked Boris Zbarsky (todo: 200+ items) <bzbarsky@mit.edu> for superreview: Bug 448281: font-size sometimes gets calculated wrong https://bugzilla.mozilla.org/show_bug.cgi?id=448281 Attachment 332497: patch 1: don't rebuild rule cascades if they're aren't currently any https://bugzilla.mozilla.org/attachment.cgi?id=332497&action=edit ...

Keyboard shortcut 'ctrl+T' doesn't always work
Name: Georgi Liubenov Email: liubenoffatmaildotbg Product: Firefox Summary: Keyboard shortcut 'ctrl+T' doesn't always work Comments: When pdf document is opened in a tab 'ctrl+T' shortcut doesn't work. I have to go to File -> New Tab to open a tab. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to provide one you must BCC (not CC) the sender for them to ...

MakeMaker and TESTS => 't/*.t t/*/*.t'
I'm maintaining a module (Regexp::Common) which has a large set of tests. Therefore I decided to not put all the test scripts in t/, but to make subdirectories in t/. I added "test => {TESTS => 't/*.t t/*/*.t'}" to the call to WriteMakefile in Makefile.PL, and all worked well. At least, so I thought. It works fine on Unix, but it seems to fail under Windows. I got the following report: Installing perl extension Writing Makefile for Regexp::Common Microsoft (R) Program Maintenance Utility Version 7.00.9466 Copyright (C) Microsoft Cor...

Please help! My mozilla won't attempt to get email, but won't say why
Since 9/4, my Mozilla has apparently stopped attempting to receive email from a POP3 server. So far as I know, my server settings are OK with my ISP, and I can use Outlook Express successfully, so its not a problem with my ISP. Is there a log somewhere, or some other diagnostic? Thanks, Ben P On 10/09/2003 14:42, Ben Pracht wrote: > Since 9/4, my Mozilla has apparently stopped attempting to receive email > from a POP3 server. So far as I know, my server settings are OK with my > ISP, and I can use Outlook Express successfully, so its not a problem with > my ...

I Don't Get $get
So I like the shorcut $get, but wouldn't it be nice if it worked on ASP controls? Unless I am missing something, I always have to do this: var serverText= $get('<%= ServerTextBox.ClientID %>'); DavidDavid McCarterMicrosoft MVPdotNetTips.comhttp://www.codeplex.com/dotNetTips Hi sddavidm, $get is a shortcut to a function inside client-side AJAX core that work similar to document.getElementById. (http://www.w3schools.com/htmldom/met_doc_getelementbyid.asp) It returns reference to a DOM element. DOM element is an object inside browser. for example the following are marku...