Setting up BlogEngine.NET 1.4 to use SQL Server

-   Jul 02, 2008 -   BlogEngine.NET, Screencasts -   , , ,

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.


amr salah
Commented on 7/12/2008 6:51:38 AM
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 .

Al Nyveldt
Commented on 7/12/2008 11:00:16 PM

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.  
Golo Roden
Commented on 7/15/2008 4:51:35 PM

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


Commented on 7/16/2008 12:41:15 PM
where do you find the schema for the new tables?
Is there a setup script available?
Al Nyveldt
Commented on 7/16/2008 2:28:20 PM
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.

Comments are closed