DNN 4.02
Win XP Pro
IIS v5.1
SQL Express v9.00.1399.06
ASP.NET v2.0.50727

I've been combing the boards and have been unable to get an install of DNN 4.02 going from the Source Code.

Below are the steps I've taken (if someone can point out my error, I'd be happy to turn this into an install guide).  I probably enabled a lot of things I didn't need to in my effort to get the thing working, so if you can point those out as well that'd be very helpful.

1. Created a directory and unzipped the DotNetNuke source file there. (Mine was C:\Inetpub\DotNetNuke_2
2. Copied Website\Install\DotNetNuke.install.config to Website folder
3. Created IIS Virtual Directory:
1. Control Panel -> Administrative Tools -> Internet Information Services
2. Open Up the tree: Internet Information Services -> MyComputer (local computer) -> Web Sites
3. Right-click on the MyComputer (default web site) and select New -> Virtual Directory
4. Click "Next"
5. Enter "DotNetNuke" for the Alias and click "Next"
6. Browse to C:\Inetpub\DotNetNuke_2\Website and click "Next"
7. Check all the following boxes: Read, Run scripts, Execute, Write.  Click "Next"
8. Click Finish
4. Finish configuring DotNetNuke Virtual Directory (right click on the Directory in IIS, "Properties")
1. Virtual Directory Tab
1. Read, Write, Log Visits, Index this Resource.
2. Execute Permissions: Scripts and Executables
3. Application Protection: Medium (Pooled)
2. Documents Tab
1. Enable Default Document: Default.aspx
3. Directory Security Tab. Left this one alone
4. ASP.NET Tab: Confirmed V2.0.5027 is enabled
5. Click "Apply" and "OK"
5. Set up SQL Server Express
1. Run SQL Server Configuration Manager
2. Navigate to SQL Server 2005 Network Configuration -> Protocols for SQLExpress
3. Enable everything (Shared Memory was enabled, I enabled Named Pipes, TCP/IP and VIA)
6. Complete setting up SQL Server Express
1. Open MS SQL Server Management Studio Express
2. Right click on the server and select “Properties”
3. Click “Security”
4. Ensure “SQL Server and Windows authentication mode” is selected
5. Click “OK”
6. Restart the server to enable all the settings just changed
1. Right click on the Server and select “Stop”, then “Yes”
2. Right click on the Server and select “Start”, then “Yes”
7. Create the Database
1. Right click on “Databases” and select “New Database…”
2. Enter Database name (DotNetNuke) and Click “OK”
8. Set up DB login (Windows authentication)
1. Expand the Security folder in the tree, right-click on Logins and select “New Login…”
2. Leave “Windows Authentication” selected, click “Search” next to Login name.
3. Enter “aspnet” in the text box and click “Check Names”; it should fill in with the ASPNET ID.
4. Expand database -> security. Right click on Users and and select “New User…”
5. Click “…” next to “Login Name”
6. Enter “aspnet” in the text box and click “Check Names”;
7. Select the checkbox next to the ASPNET ID and click “OK”
8. Click “OK”
9. For User Name enter “DotNetNuke”
10. For “default schema”, enter “dbo”
11. For “schemas owned by this user”, check db_owner
12. For “Database role membership”, check db_owner
13. Click OK
9. Set up another DB login (SQL server authentication)
1. Expand the Security folder in the tree, right-click on Logins and select “New Login…”
2. Select “SQL Server Authentication”
3. Enter the login name (MyLogin)
4. Enter the password (mypwd)
5. Clear the checkbox for “Enforce Password Policy”
6. Select the database from the “default database” dropdown (MyDB)
7. Click OK
10. Make a new copy of resources.config and name it web.config
11. Update web.config to use the SQLexpress section. I’m thinking this didn’t work because there is no reference to the userID and PW.
1. In <connectionstrings> area,    
   <add
         name=”SiteSqlServer”
         connectionString=”Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DotNetNuke.mdf;”
         providerName=”System.Data.SqlClient” />
2. In <appsettings> area
   <add
         name=”SiteSqlServer”
         connectionString=”Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DotNetNuke.mdf;”
         providerName=”System.Data.SqlClient” />
3. In <providers> area (line 372), added the DNN table prefix
   objectQualifier="dnn_"

Result: Could not find file 'C:\Inetpub\DotNetNuke_2\Website\Providers\DataProviders\SqlDataProvider\DotNetNuke_template.mdf'.

Next attempt with web.config

1. In <connectionStrings> area
1. Comment out the SQL Express section
2. Uncomment the SQL Server section
3. Update the SQL Server section
           <add
         name="SiteSqlServer"
   connectionString="Server=(local);Database= MyDB;uid= MyLogin;pwd= mypwd;"
         providerName="System.Data.SqlClient" />

2. In <appSettings> area
1. Comment out the SQL Express section
2. Uncomment the SQL Server section
3. Update the SQL Server section
       <add key="SiteSqlServer" value="Server=(local);Database=MyDB;uid= MyLogin;pwd=mypwd;"/>

Result: Huge error, beginning with: ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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)

Next attempt:

11. In <connectionStrings> area
1. Comment out the SQL Server section
2. Uncomment the SQL Express section
3. Update the SQL Express section
   <add
         name=”SiteSqlServer”
         connectionString=”Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DotNetNuke.mdf;uid=MyLogin;pwd=mypwd;”
         providerName=”System.Data.SqlClient” />
12. In <appSettings> area
1. Comment out the SQL Server section
2. Uncomment the SQL Express section
3. Update the SQL Express section
   <add
         name=”SiteSqlServer”
         connectionString=”Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|DotNetNuke.mdf;uid=MyLogin;pwd=mypwd;”
         providerName=”System.Data.SqlClient” />

Result: Could not find file 'C:\Inetpub\DotNetNuke_2\Website\Providers\DataProviders\SqlDataProvider\DotNetNuke_template.mdf'.

Any other suggestions?

In reading the instructions and the boards, it didn’t look like I needed to do anything with a template; is that incorrect?

KRF