Hi, I am coming accross a prob with the core DNN forums. I have set up a DNN site, published with webmatrix, however when I add the core forums on localhost, and the try to publish with webmatrix I get the following error: 23:13:00: "CREATE VIEW [dbo].[Forum_vw_ForumUsers]" 23:13:00: Invalid column name 'EnableDisplayInMemberList'. 23:13:00: Invalid column name 'EnablePM'. 23:13:00: Invalid column name 'EnableDisplayInMemberList'. http://go.microsoft.com/fwlink/?LinkId=178587 I read on IIS.net to try publishing first without db owner credentials. Anyone else came accross this, and found a workaround. How do you publish with out being db owner - the user is automatical set when you create db from control panel, and unless I'm missing something it's not editable. I am on your 2012 servers, and tried with sql 2012 and 2008r2 db's but same prob with each. Thanks for any help.
You cannot create database objects in general and views in particular unless your database user has permissions to create them. db_owner and db_ddladmin fixed database roles will give you necessary permissions to create database objects. Please use your primary sql login of your database as it has dbo permissions on your database by default.
