I am very new to DNN and having problems with the installation and would welcome some help!

Environment:  Windows Server 2008 R2, SQL Server Express 2008 R2, IIS 7.0 - Admin access via Remote Desktop

I installed DNN Community Edition (05.06.02) using the MS Web Platform Installer. Upon starting the DNN installation on the first screen I get a message stating that "The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database....", I select the "Typical" installation and click on the Next button.

It goes to the Permissions page which I get a message stating "Your site passed the permissions check.", then I select the Next button.

Now on the Configure Database Connection page which I have tried several different ways:

1.    Using default settings:
        Select Database: SQL Server 2005/2008 (Express) File
        Server: .\SQLExpress
        Filename: Database.mdf
        Integrated Security:        checked
        Run as db Owner:    checked

        Error after clicking Next button:
            Connection Error(s):
            Index #: 0
            Source: .Net SqlClient Data Provider
            Class: 14
            Number: 15382
            Message:

 

2.    Specifing IP address for server and User ID/Password:
        Select Database: SQL Server 2005/2008 (Express) File
        Server: -Server IP Address-\SQLExpress
        Filename: Database.mdf
        Integrated Security:        unchecked
        User ID:                                sa
        Password:           xxxxxxxxxxxxx
        Run as db Owner:    checked

Error after clicking Next button, which take me to another page with the following error messages:

DotNetNuke Error
--------------------------------------------------------------------------------

System.ArgumentException: Invalid value for key 'attachdbfilename'. at System.Data.SqlClient.SqlConnectionString.VerifyLocalHostAndFixup(String& host, Boolean enforceLocalHost, Boolean fixup) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.TestDatabaseConnection(DbConnectionStringBuilder builder, String Owner, String Qualifier) at DotNetNuke.Services.Install.InstallWizard.TestDatabaseConnection() at DotNetNuke.Services.Install.InstallWizard.wizInstall_NextButtonClick(Object sender, WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

 

Jerry,

If you have created an empty database and database user login for SQL Server Authentication you will not be making use of the Databae.mdf file included in the DotNetNuke install package. Therefore, even when your database server is SQL Server Express, you MUST select SQL Server 2005/2008 and not SQL Server 2005/2008 (Express). The Express option only works with a attached mdf file - hence your second error.

Because of potential problems with accessing the Database.mdf file after touching it outside of DNN (for example with SQL Server Management Studio) to add custom tables, or to look at the database structure or to make a backup for tranfer to a remote hosting provider) I always recommend creating an empty database prior to DNN installation and using the install wizard's SQL Server 2005/2008 (not express) option.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner