This was extremely helpful in getting DNN to run under SQL Express. I have always used SQL Server, but have a need for a particular project to use SQL Express.
However, I am hoping that someone from the DNN Core Team can speak to the intention of the db settings in the webconfig as they are. I think the intent is to use SQL express in a much easier way than described here, if so, getting it to work that way might be a much simpler install, from the DB prespective anyway.
Looking at the webconfig as written, it seems like it is suppose to attach the db in the SQL environment, then I assume there are scripts in DNN to the db connection settings to point to the database. Also, it is using integrated security as written, so then presumably the security contect for accessing the DB is not the anon IIS user, but the ASP.Net or Network objects that interact so they have access?
Does any of this makes sense? Is it possible to use the SQL Express connection as written, if so, what if any changes need to be made it, or to the SQL Environment (i.e., logins) to make it work?
Thanks!
Paul Kavanagh