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.

💬 5 Replies
👁️‍🗨️ 1150 Views



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: