locked
Cannot open Sourcesafe Database - None of our logins work RRS feed

  • Question

  • Here is the sequence of events:

    1) Was adding a new user to the database using Sourcesafe Administrator (admin login) on a laptop connected to the network via wifi.  During the creation of this user the laptop froze and I had to hard reboot it.

    2) Now none of our users are able to login to Sourcesafe.  When you type in the password it just returns to the same dialog box instead of launching VSS.  Typing an incorrect password does bring up a notification prompt that reports "incorrect password" as expected.

    3) I have run an analyze on the database to no avail (it found some timestamp mismatches on a few files which it did resolve) however we still cannot login.

    4) I attempted to remove the names.dat, rights.dat and status.dat files from the \data directory so that analyze would rebuild them.  It did -- however still no luck getting into either VSS or VSS Admin.

    We are hoping there is a step we have overlooked that might restore our access. It appears that something to do with the password/user management got hosed and now it just never gets pass the initial login screen.

    Wednesday, August 29, 2012 8:22 PM

Answers

  • We finally fixed the issue this past weekend.  Somehow when creating the new user (and the network connection dropped) - the user.txt file dissappeared.  We manually recreated the user.txt file and it started working again fine!
    • Marked as answer by limaxfunfe Wednesday, September 5, 2012 5:08 PM
    Wednesday, September 5, 2012 5:07 PM

All replies

  • As an update to the above:

    1) We attempted to recreate the um.dat file by creating a new blank database.
    2) Overwrote the um.dat file in the {database}\data folder.
    3) Deleted names.dat, rights.dat and status.dat and ran analyze to rebuild all the permissions, etc.
    4) Attempted to login using "admin" with no password.

    The behavior is still the same -- pressing enter remains at the sourcesafe login screen whereas typing any incorrect password or user name reports that the password is incorrect/user does not exist.

    This is now with a fresh VSS2005 install on a clean machine with the admin tools loaded.  We also attempted to copy the VSS database to the local c: drive and the result was identical.  Opening other databases is no problem but our main production database is somehow locked.

    Wednesday, August 29, 2012 10:53 PM
  • Please check the "users" folder attributes, and check the "user name" folder s and inner files also. Check logs in the "data\loggedin" folder.


    Bob Bao [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, August 30, 2012 8:31 AM
    Moderator
  • You may backup the main database and try running Analyze to see if it helps solve the problem.

    _________________________

    Catherine Sea
    TFS Hosting | Version Control Solutions

    Friday, August 31, 2012 5:40 AM
  • any update

    Bob Bao [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, September 5, 2012 6:40 AM
    Moderator
  • We finally fixed the issue this past weekend.  Somehow when creating the new user (and the network connection dropped) - the user.txt file dissappeared.  We manually recreated the user.txt file and it started working again fine!
    • Marked as answer by limaxfunfe Wednesday, September 5, 2012 5:08 PM
    Wednesday, September 5, 2012 5:07 PM
  • The users.txt file should exist in the same folder as the srssafe.ini file.  The users.txt file references the folder where each users information is kept and it appears that when the new user was being added somehow the file didn't get written back to disk so everytime we tried to login - the reference for the users folder could not be found causing our issue.  It was a lot of trial and error (running analyze, etc.) till we discovered the difference between our current database and a normal working database (the missing users.txt file).
    Wednesday, September 5, 2012 5:10 PM