locked
Install DB RRS feed

  • Question

  • User-1595400206 posted

    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?

    Wednesday, June 1, 2005 11:18 AM

All replies

  • User952890750 posted

    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.

     

    Monday, July 18, 2005 12:45 PM
  • User992575777 posted
    And then on the later versions of the framework, you have to also make sure that you add the Roles in aspnet_Roles database.

    Tuesday, August 9, 2005 1:24 AM
  • User263541371 posted

    Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

    I need more detailed instructions on <o:p></o:p>

    how to make the project working with<o:p></o:p>

    sqlserver 2000 database<o:p></o:p>

                             thanks in advance…<o:p></o:p>

     

    Wednesday, November 9, 2005 6:12 AM
  • User952890750 posted
    What specifically are you having difficutly with? 
    Wednesday, November 9, 2005 8:58 AM
  • User1416329745 posted

    Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

    I need more detailed instructions on <o:p></o:p>

    how to make the project working with<o:p></o:p>

    sqlserver 2000 database<o:p></o:p>

                             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

    Wednesday, November 9, 2005 9:15 AM
  • User952890750 posted
    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?
    Wednesday, November 9, 2005 9:24 AM
  • User1416329745 posted

    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.

    Wednesday, November 9, 2005 9:33 AM