Setting up BlogEngine.NET 1.4 to use SQL Server

SQLSnip BlogEngine.NET 1.4 supports storing your data pretty much however you’d like.  By default, it will store your data using XML.  However, with a few simple steps you can be running your entire blog off of a database.  Today, I put together a new screencast to show you exactly how to configure your blog to use SQL Server.  For the veterans out there, there is some key changes in BlogEngine.NET 1.4, so it should be worth watching for you as well.

It is important to point out that this screencast starts with BlogEngine.NET 1.4 installed with the default providers.  If you need help getting to that point, please watch the installing BlogEngine.NET 1.4 screencast.

It is important to know that BlogEngine.NET actually has 4 providers that can be configured.

  • Blog Provider – Store posts, pages, settings, etc.
  • Membership Provider – Store user names, passwords, etc.
  • Role Provider – The role the users are in.  (Administrator, Editor)
  • Profile Provider – Information about the users.

This new screencast will walk you through getting the BlogProvider and the ProfileProvider setup using the new DbBlogProvider and DbProfileProvider. 

MembershipSnip For SQL Server, I’d recommend using the SQLMembershipProvider and the SQLRoleProvider that are built in to the .NET Framework.  I made a screencast a while back on getting these set up, so I figured I’d save the effort and just link to it again for setting up these providers.  Nothing has changed in the configuration.

Comments

7/12/2008 9:51:38 AM #

amr salah

Your screen cast is totally wrong , as it is based on a script that is missing the user table be_users .  
You should fix this before you let users waste  hours trying to fix it , or at least not release such a broken feature .  

The problem is , you did not just give a broken script , you made an entire screen cast based on it  . Tough .

amr salah United States |

7/13/2008 2:00:16 AM #

Al Nyveldt

Amr,

I'm really sorry you are confused about the Membership and Role Provider usage with SQL Server.  I strongly recommend that you use the SqlMembershipProvider and the SqlRoleProvider when using SQL Server.  

Since Microsoft has already built these providers for SQL Server (and they are much more completely implemented), it seems best to use them.  If you use these 2 providers, there is no need to have be_Users, be_Roles, or be_UserRoles in your database.  This is why I did not include them in the script.

Of course, if you really want to use DbMembershipProvider and DbRoleProvider with SQL Server, you are welcome to, but as you have found, you will need these new tables.  

Al Nyveldt United States |

7/15/2008 7:51:35 PM #

Golo Roden

Hi,

where do you find the schema for the new tables? Is there a setup script available?

Cheerio,


Golo

Golo Roden Germany |

7/16/2008 3:41:15 PM #

sandeep

where do you find the schema for the new tables?
Is there a setup script available?

sandeep India |

7/16/2008 5:28:20 PM #

Al Nyveldt

The SQL Script for the BlogProvider and ProfileProvider tables is in the Setup folder of your BlogEngine site.

The SQL Script for the SQLMembershipProvider and SQLRoleProvider is on your PC.  Usually found at C:\Windows\Microsoft.NET \Framework\v2.0.50727\aspnet_regsql.exe.

Al

Al Nyveldt United States |

8/13/2008 6:28:02 AM #

trackback

Trackback from BizTron

Adding new features to BlogEngine.NET

BizTron |

6/21/2009 5:22:18 AM #

trackback

Adding new features to BlogEngine.NET

Adding new features to BlogEngine.NET

BizTron |

Comments are closed
Recent Comments