Im trying to 'knit in' the blogengine to an existing site. I use SQL Server and my website uses roles and membership. Ive used the standalone instance of the blogengine for testing, modifyng the appropriate sections in the web.config. This works OK and
I can use my database with blogengine. However, when I then try to use it with my existing website, I get this error
Cannot insert the value NULL into column 'RoleId', table 'studio_db.dbo.aspnet_Roles'; column does not allow nulls. INSERT fails.
The statement has been terminated.
I have this in my web.config
<!--<add name="XmlBlogProvider" type="BlogEngine.Core.Providers.XmlBlogProvider, BlogEngine.Core"/>-->
<add name="DbBlogProvider" type="BlogEngine.Core.Providers.DbBlogProvider, BlogEngine.Core" connectionStringName="BlogEngine"/>
<add name="BlogEngine" connectionString="packet size=4096;user id=appropriateuser;data source=PC\SQLSERVER2005DEV;persist security info=True;initial catalog=Studio_db;password=appropriatepassword;" providerName="System.Data.SqlClient"/>
the username and password I use DOES have sufficient privileges, but I dont understand why the blog engine attempts to insert something in the database as soon as I attempt to load the default.aspx page of the blogger
can anyone help me out with this ? its proving to be very difficult to 'bolt' this into an existing website