4/19/2007 Changes
I've made dozens of fixes and correctted some problems I was having with TFS. The new code has support for photo galleries, static pages, pinned articles, etc. A new official release should be available soon.

11/05/2006 Changes
I've checked in more changes that address some bug fixes and missing functionality that is required to make the site operate that I ran into these issues while setting up ryanandkimberly.com.

SQL 2000 Support
If you're going to run SBN on a SQL 2000 database, you'll need to rename sys.objects to sysobjects and "objectid = OBJECTID" to "id = OBJECT_ID" in the change scripts and stored procedures.

10/22/2006 Changes
I checked in a huge set of changes, including several database changes. The code includes numerous fixes and several security enhancments to prevent people from posting spam in your blogs. Things include: optional user registration, software autoposter prevention, maximum login attempts, ip address blocking and several GUI enhancements. If you're updating an existing database you'll need to make sure you publish your existing blog entries before they'll reappear on your site.

I made several changes recently and you'll need to make sure to run the change scripts and the new stored procedures (not the ones in the V2 folder) regardless if you have an old database or if you just created a new one from the create scripts.

Simple Blog .Net (SBN)
SBN is simple to setup, simple to use blogging application build on top of the .Net 2.0 framework and SQL 2005 (although it'll work in 2000).

Release 2 is available at http://www.infinityball.net, it has some issues (nothing major) that I'm working on right now and I should have a stable release on CodePlex soon. Or you can just download Change Set 3222 or higher.

-SQL Server 2005 (2000 works too)
-Web server capable of running ASP.Net 2.0 code
-Privledges to setup the database and web site

Installation is pretty easy. First you need to download the latest source code or grab one of the releases (shouldn't make a big difference unless you're already running an old version of SBN). Both the release and source contain a folder called "SimpleBlogData", inside that folder is a "Create Scripts" folder. This contains the sql script that will build the initial database or upgrade your current DB to the latest version. In SQL Server, create a new, empty database (i.e. SimpleBlog), then run the create script on the that database. This will setup the tables and stored procedures you need to run SBN. Depending on your SQL Server security setup you'll most likely have to create a SQL user that can access the DB and you may have to give that user execute permissions on the stored procedures. Once that is done, you'll need to copy the contents of the "SimpleBlogWeb" folder that came with the source or release to the server where you'll be hosting SBN. Next you'll need to modify the web.config file found in the root of the SBN web site you're creating. Modify the ConnectionString property and SMTPServer properties to match the settings for your web site. Once that is done you should be able to visit your SBN web site and you will be prompted to setup the admin user. After that the site should be fully operational.

Lost Admin Password
If you lost your admin password, the only way to recover it is to modify the sbusers table in the database. To reset the password, find your admin user account in sbusers and modify the password field to be "admin". The word "admin" is a reserved word that will not require or be encrypted to login, this will allow you to login with the password 'admin' and change it to something more secure through the settings page.

Planned Features
  • AJAX enabled image gallery
  • Enhanced settings page
  • SimpleNav control will be database driven
  • Toolbar navigation control
  • Themes
  • RSS support (available in the latest build and currently being tested at http://www.infinityball.net/rss.aspx
  • Rich text editor for article entry
  • Article and comment ranking system

Sites Using SBN

Last edited Apr 20, 2007 at 12:10 AM by rrife, version 23