locked
Database Script RRS feed

  • Question

  • User423555123 posted

    Hey all,

     I downloaded and installed this and it worked once for me, then it errors out. I have the Standard Version of SQL Server on my machine and it gives me an error saying that it cannot connect using the SQLEXPRESS. Obviously its not installed.

    Does anyone have the script that i can run to create the DB in SQL? Can you post it here or email it to me???

    Thursday, July 19, 2007 4:29 PM

Answers

  • User555306248 posted

    If your connectionString is right, then why can't you connect to the DB...?

    In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..

    You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

    aspnet_regsql, it will open one window, where you  have to configure DB.

    Hope it will help you, let me know.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, July 22, 2007 11:57 PM

All replies

  • User555306248 posted

    Check in web.config for connectionString, configure it according to your server name, password etc.

    Let me know if this helps you.

    Thursday, July 19, 2007 11:43 PM
  • User423555123 posted

    Right, sorry i should have been a little more clear. I did that and it points at the database. The issue i am having is that I have the script it gives you to create the tables and all the PK and FK and whatnot, the issue is that it didnt give me the script to create the user table (for example). So i was hoping that maybe someone has the db all up and running and could script it out for me.

    Friday, July 20, 2007 4:53 PM
  • User555306248 posted

    If your connectionString is right, then why can't you connect to the DB...?

    In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..

    You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

    aspnet_regsql, it will open one window, where you  have to configure DB.

    Hope it will help you, let me know.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, July 22, 2007 11:57 PM
  • User555306248 posted

    Have you tried, what I suggested to you.

    Let me know whether it is helpful to you.

    Monday, July 23, 2007 11:58 PM
  • User555306248 posted

    Have you got any solution or solved your problem ?

    Post it on forum.

    Tuesday, July 24, 2007 11:43 PM
  • User423555123 posted

    lol, sorry sorry. i got so caught up in it i forgot to mark it.

     I just had to register my db with the command line tool.

     Thank you for your help!

    Wednesday, July 25, 2007 4:44 PM
  • User555306248 posted

    Great....Thanks for marking as answer.

    Wednesday, July 25, 2007 11:50 PM