Getting started with the SubSonic Starter Site on Ms SQL Server 2000
Wed, May 23 2007 12:16 AM
First a pre requisite:
You need to have asp.net Ajax installed.
Get it at:
Then we need to set up the database, there are some scripts included with the startersite.
These are located in:
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:
This is to setup the membership part.
After that run:
To add the roles + users used by the StarterSite.
After that set up the StarterSite itself by running:
Last but not least, Edit the web.config file connectionstrings setting to be something like this:
<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;" />
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.