Running Club Site on a Hosted/shared SQL2000 DB

Question

User-1909038188 posted

In reviewing related posts and referenced blogs it appears that a club site based web site cannot be run in an environment where I buy a single SQL2000 database through a provider? I am trying to verify that before I scrap my project.

The club site depends on the tables and SPs found in ASPNETDB. If I try to run aspnet_regsql.exe it fails since my DB login does not have rights to delete or create databases. Am I correct that this is a dead end?

Answer 1

User-1653776603 posted

The clubsite as shipped uses 2 databases, one for memberhsip, the other for the club data. This was done just to smplify the dev experience, so you have a clean club database.

You should be able to combine the club data with the membership data in the same database, its just a matter of merging the sql scripts for both, and then using the same connection string.

Answer 2

User-1732195092 posted
Are these SQL scripts available to new users?  I'm having trouble using the starter kit on a hosted site.