Posted on 8:27 AM by Softminer and filed under , ,

First Download the latest version of BlogEngine from following URL

by defualt BlogEngine is using XmlBlogProvider. therefore all data is saved in APP_DATA in XML files.

to change it to SQL Server follow the instructions:

create a Database in SQL Server 2005 or 2008.

Run the SQL script on you Database, the script is in this Folder:

Replace SQLServerWeb.config with Web.config

change the connection string in Web.config to your DB connection

change the blogProvider from XmlBlogProvider to DbBlogProvider

<blogProvider defaultProvider="DbBlogProvider">
 <add name="XmlBlogProvider" type="BlogEngine.Core.Providers.XmlBlogProvider, BlogEngine.Core"/>
 <add name="DbBlogProvider" type="BlogEngine.Core.Providers.DbBlogProvider, BlogEngine.Core" connectionStringName="BlogEngine"/>

The appliction should be runnable now.

PS: for importing Post you can use
call the service with WCF TestClient
Responses to ... Installing BlogEngine on SQL Server