Mischa Kroon

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.