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>