Install DB

Last post 11-09-2005 9:33 AM by Caddre. 7 replies.

Sort Posts:

  • Install DB

    06-01-2005, 11:18 AM
    • Member
      5 point Member
    • Raynos
    • Member since 06-01-2005, 3:15 PM
    • Posts 1

    I'm new in asp.net.

     I've install timetracker, but it seem like it didn't install the database to my SQL server. But I can't find any document to install the database. Am I missing something?

  • Re: Install DB

    07-18-2005, 12:45 PM
    • Participant
      1,800 point Participant
    • chuck.boyer
    • Member since 08-19-2004, 1:39 PM
    • Reston, VA
    • Posts 364

    It uses SQL Express by default.  If you want to connect to a "corporate" db, you need to create the db on the server, run the DBSchema.sql file in the App_Data Directory, then configure the asp.net membership/profile schema by going to your framework/v2.0 directory and running aspnet_regqsl.  After doing that, you need to modify the connection string in the web.config.

     

    Chuck Boyer, MCSD .NET
    Director of Production and Development
    Edge Media Design
  • Re: Install DB

    08-09-2005, 1:24 AM
    • Participant
      766 point Participant
    • benmiller
    • Member since 06-10-2002, 11:53 PM
    • Lehi, UT
    • Posts 154
    And then on the later versions of the framework, you have to also make sure that you add the Roles in aspnet_Roles database.

    Please: Don't forget to click "Mark as Answer" on the post that helped you.

    Get Lucky - Win a sweepstake at SweepstakesToday.com
  • Re: Install DB

    11-09-2005, 6:12 AM
    • Member
      20 point Member
    • yuval
    • Member since 06-22-2005, 7:36 AM
    • Posts 4

    Hi

    I need more detailed instructions on

    how to make the project working with

    sqlserver 2000 database

                             thanks in advance…

     

    yuval
  • Re: Install DB

    11-09-2005, 8:58 AM
    • Participant
      1,800 point Participant
    • chuck.boyer
    • Member since 08-19-2004, 1:39 PM
    • Reston, VA
    • Posts 364
    What specifically are you having difficutly with? 
    Chuck Boyer, MCSD .NET
    Director of Production and Development
    Edge Media Design
  • Re: Install DB

    11-09-2005, 9:15 AM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308
     yuval wrote:

    Hi

    I need more detailed instructions on

    how to make the project working with

    sqlserver 2000 database

                             thanks in advance…



    Download AdventureWorks2000 from the link below and install it Time Tracker will use AdventureWorks to create a new database during installation.  Your SQL Server 2000 must be service pack 3a and above.  If you have problems send me an email the address is in my profile I will send you the install .SQL file.  Hope this helps.
    http://www.microsoft.com/downloads/details.aspx?FamilyID=487c9c23-2356-436e-94a8-2bfb66f0abdc&DisplayLang=en

    Kind regards,
    Gift Peddie
  • Re: Install DB

    11-09-2005, 9:24 AM
    • Participant
      1,800 point Participant
    • chuck.boyer
    • Member since 08-19-2004, 1:39 PM
    • Reston, VA
    • Posts 364
    Why on earth would you install AdventureWorks to get the time tracker app to work?  Why not just follow the instructions I posted above by just creating a database on the SQL2K machine and running the dbschema.sql file that comes with the Time Tracker app?
    Chuck Boyer, MCSD .NET
    Director of Production and Development
    Edge Media Design
  • Re: Install DB

    11-09-2005, 9:33 AM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308

    AdventureWorks2000 is the template used to create most Microsoft sample applications is the reason.  You posted your instructions before the person posted so your instructions could have been used before the post.

    Kind regards,
    Gift Peddie
Page 1 of 1 (8 items)