Getting started with the SubSonic Starter Site on Ms SQL Server 2000

Mischa Kroon — Tue, 22 May 2007 13:16:00 GMT

First a pre requisite:
You need to have asp.net Ajax installed.
Get it at:
http://ajax.asp.net

Then we need to set up the database, there are some scripts included with the startersite.

These are located in:
SubSonicStarter\App_Data\Scripts

To be able to execute these scripts you will need to create a database.
This can be done through Enterprise Manager or through other sql server management tools.

The StarterSite is set up to use 2 different databases 1 for membership and 1 for the StarterSite Data itself.
Personally I would use only one database, but if you want to make 2 seperate databases that will work ok as well.

The original scripts of the starterkit have 2 main problems:
1 - The subsonic script doesn't support SQL Server 2000
2 - They don't contain the sample data.

To resolve these issues I have created 2 files to resolve the problem.

From the SubSonicStarter\App_Data\Scripts directory execute the:
Membership.sql

This is to setup the membership part.
After that run:
http://fnmstudios.net/blog/code/Subsonicv2/SubsonicStarterKit%20v2.01%20SQL%202000%20Membership%20Content%20Script.txt

To add the roles + users used by the StarterSite.

After that set up the StarterSite itself by running:
http://fnmstudios.net/blog/code/Subsonicv2/SubSonicStarterKit%20v2.01%20SQL%202000%20Script.txt

Last but not least, Edit the web.config file connectionstrings setting to be something like this:
<connectionStrings>
<clear/>
<add name="CMS" connectionString="Data Source=(local);Initial Catalog=SS_StarterSite;Integrated Security=SSPI;" />
<add name="LocalSqlServer" connectionString="Data Source=(local);Initial Catalog=SS_StarterSite;Integrated Security=SSPI;" />
</connectionStrings>

Where SS_StarterSite can be replaced with your chosen Database Name :)

I hope that this will get you started with the SubSonic StarterSite on Ms SQL Server 2000.

Search results matching tags 'ASP.NET' and 'SQL Server'

Getting started with the SubSonic Starter Site on Ms SQL Server 2000