Installation HowTo

Introduction

This page will guide you through the installation process. It's pretty easy.

Prerequisites

Microsoft Windows 2000, 2003, XP or Vista
Microsoft SQL Server 2005
Microsoft .NET Framework 2.0
Microsoft IIS 6.0 or 7.0 running ASP.NET 2.0
Microsoft Web Services Extensions (WSE) 3.0

Installation

Binaries

There's currently no public distribution of the software available. You must build the SnCore.Web.Deploy project and use the generated drop. See Dev HowTo for source code.

Database Components

Open the SQL Server Enterprise Manager.
Create a blank database with full text indexing, called SnCore that will host your data. Open SQL Server Group, Local, Databases, right click on Databases and choose New Database. Make sure to check Use full text indexing.
Create a full text catalog for full text search. Right click on the database, choose Storage, Full Text Catalogs and New Full Text Catalog. Use the name SnCore for your full text catalog.
Create a login for the ASP.NET user or NT AUTHORITY\Network Services (Windows 2003). Open SQL Server Group, Security, right click on Logins and choose New Login. Browse for local ASPNET account.
Create a user that will access the database. Open SQL Server Group, Databases, choose your newly created database, right click on Users. Choose New Database User. Choose the previously created ASPNET or NT AUTHORITY\Network Services user in Login Name. Check db_owner and Save.
Populate the database schema. Open SQL Server Query Analyzer. Choose the SnCore database. Open the file SnCore.Data/SnCoreSqlServer.sql from the distribution and run it. This will populate the Blog database with a number of tables, stored procedures, etc.
Populate initial data for system tables. Open SQL Server Query Analyzer. Choose the SnCore database. Open the file SnCore.Data/PopulateData.sql from the distribution, edit the paths to the data files and run it. This creates initial regional data, built-in bug tracking fields, etc.

Web Components

If you are building the code you may skip this step. Visual Studio 2005 will create the virtual directories for you.

Ensure that your web server runs ASP.NET 2.0. If necessary, run aspnet_regiis.exe -i from \WINDOWS\Microsoft.NET\Framework\v2.0.50727.
Create a virtual directory in IIS called SnCore. Point the Home Directory to the SnCore.Web directory in the drop. This may also be the root of your website. Add Default.aspx to default documents of this site. On IIS7 you must also run the Virtual Directory with permissions for a specific account that has r/w access to the bin subdirectory.

Upgrading to a Newer Version

If you are building the code all you have to do is update the database schema.

Backup your database and files, especially web.config.
Open SQL query analyzer and execute SnCore.Data/SnCoreSqlServer.sql. Your data will be preserved.
Re-deploy all the content and compiled assemblies from the SnCore.Deploy project.

First Steps and Simple Tasks

Navigate to the website. This is typically http://localhost/SnCoreWeb/. By default the system creates an administrative account with username: admin@localhost.com and password: password.

Configure global Settings.
Create a discussion for technical issues.
Create a bug project for tracking.