Last post Jul 31, 2006 06:15 PM by SokyNet
Feb 06, 2006 01:44 PM|davedisc|LINK
I am trying to set up the VS CS version of the Time Tracker Starter Kit. When I get to the DB install, the dialog says "Please select the local database instance where you would like to have the TimeTracker database installed:" and the dropdown shows "localhost"
which I can't change. When I try to test the connection it fails with a messagebox saying "Unsuccessful database connection."
My database instance is unnamed. I don't know where the "localhost" name is coming from.
I have configured my Windows login to have dbo and administrator access to the Master DB and SQL server respectively. It's a local SQL server 2000. I'm an admin on the machine which is XP Pro SP 2 as well.
Mar 03, 2006 09:15 AM|DEW0362|LINK
I expereinced the same problem then I selected setup as remote and time tracker installed properly. You will then receive a web page that explains how to configure your site and the db even on SQL. Good Luck
Mar 03, 2006 11:23 PM|monu245|LINK
Apr 19, 2006 10:44 PM|shirley9102|LINK
I have the same problem.
Have you resolved it ? And how ?
Jul 31, 2006 12:35 PM|SokyNet|LINK
I'm having the same symptoms and I think it's related to the default installation looking for sql2005 - Since I have a full version already running I did not install that component of visual web developer.
I found the sql script in the app data folder and thought I was golden. But, somehow the enterprise manager snap in for sql2000. It looks like I have to do a "reinstall" / repair before I can find out if this is the solution.
Anyway, while I'm at it. Has anyone successfully created the database in 2000 and run the script to make this work? Or, am I chasing my tail?
Jul 31, 2006 04:01 PM|SokyNet|LINK
Whew, that took some doing. I had to remove SQL 2000 from my computer completely before I could get it to work again. Yes, I did the setup, then even added a component that wasn't installed. Then I did a registry rebuild. Nothing. Had to completely uninstall
sql from my computer, then reinstall it. Now it works... oh... except for the fact it deleted all my databases. I would be a little torqued right now if I wasn't using the developer version for what its intended... just a test bed for the production servers.
So, everything is out there somewhere.
Anyway, I've given up on this for now because I have some production work to accomplish before reporting for jury duty tomorrow. If anyone can contribute something to this mystery I would appreciate it.
Jul 31, 2006 06:15 PM|SokyNet|LINK
Well... I was wrong. I created the database and then ran the included sql script. It would appear the asp users were not created either so... I'm outa luck.
I hope others have better luck with this than I did.