EDIT: OK, The video3 makes an assumption that IIS is using DefaultAppPool. For those not installing on a fresh install off IIS, and having permission issues... read on.


I believe the video is technically incorrect for assigning app pool and file permissions. The two combinations are mismatch.

When creating the site in IIS 7.5 your application pool should match the user permissions given write access to the root folder. In the video we are instructed to choose "Classic .NET AppPool". We are then instructed to add the user "IIS AppPool\DefaultAppPool" which leads to "DefaultAppPool".

This will only work if IIS is set up globally to set The Default DefaultAppPool. So a notation should be added the the Identity needs to be set to DefaultAppPool inside the Application Pool Advanced Settings.

More correctly for utilizing the granular permission introduced with IIS 7.5 would be to keep the name assigned by IIS for Application Pool to match your new site.

I believe it should be application pool = mynewsitePool, then you can add the user permission to the root folder by typing IIs AppPool\mynewsitePool.

A little better explanation: Here.

I was also confused why the app pool selected under permissions did not match the app pool assigned to the application. I just used defaultappPool instead of the clasic.net, and it works. I then went a step further and created a dedicated app pool for the site. As you say, as long as permissions for the app pool are assigned to the folder, it works great. Maybe a bit more could have been said on this topic.

In the videos Lee shows 2 different options of installing the database. The first option has DNN install it in the appData folder within the application. The second option is to create it manually from SQL management studio.

I tried both to make sure I could get them both to work. Success. I do have a question about when you would use one method vs the other.

Also if I was to create a site with the first method, is there a way to change the site over to the other way?

Is there a detailed SQL video on here?

Thanks Lee. The videos are great. I just wish I didnt wait 4 years to finally sign up for the magazine.

I personally prefer the option of having a database set up in SQL Server.

I assume that there are ways to move from one to the other, but I've never tried it.

And ... welcome to subscribership!

Hi there,

suddenly i have the installation error on all dnn versions both in WVD and in Web Matrix:
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 4064
Message: Cannot open user default database. Login failed.

Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Login failed for user 'SOFT2\ASPNET'.

and it was also disaibled "auto" option with dnn install.

well, looked in bunch of online solutions, but basically, as i am using and dnn, and sql and Vs, WVD and Matrix for years, all solutions pointed on various things - but solution i actully very simple: if you have upgrade sql to sp3 - just simple uninstall that particular update, and dnn will run as always (with "auto" option) in VS, WVD and Matrix.

den