Softminer.net

First Download the latest version of BlogEngine from following URL
http://blogengine.codeplex.com/

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:
BlogEngine.Web\setup\SQLServer\

Replace SQLServerWeb.config with Web.config

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

change the blogProvider from XmlBlogProvider to DbBlogProvider

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

The appliction should be runnable now.

PS: for importing Post you can use
bin/BlogImporter.asmx
call the service with WCF TestClient