locked
Running Club Site on a Hosted/shared SQL2000 DB RRS feed

  • 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?

    Thursday, January 5, 2006 7:34 PM

All replies

  • 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.

    Friday, January 6, 2006 3:49 PM
  • User-1732195092 posted
    Are these SQL scripts available to new users?  I'm having trouble using the starter kit on a hosted site.
    Saturday, January 7, 2006 9:22 PM