Locked out after Vault 4.0 upgrade

[bnott]

Having several problems getting vault working now that I've upgraded.

1) There is no shortcut that I can find to the admin tool. I found on the forum I should go to http://localhost/vaultservice/index.html and click Log In.

2) But when I do that, I get a 404. I found another post on the forum that says I could go to http://localhost/VaultService/vaultweb/login.aspx, which seems to work for now, except

3) When I try to login as "admin", it says my username and password are not valid. I know they are however, and the password worked just fine (as expected) during upgrade. So I can't get in as admin.

4) But I also can't get in as a user. I have been in the free single user account of Vault 3.5. But now it tells me user logins are disabled because there is no serial number. I only have the one user though. Of course, per 3), I can't login as admin to try to do anything about it.

Thanks,
Brian

[Beth]

The Admin password is set during the install and not used for the install itself.

I think the first thing that should be tried is to uninstall Vault, but keep your database, and then attempt a fresh install. Pay special attention to the window where you enter the new Admin password (it can remain the same too).

Let me know after that if it continues to not allow an Admin login.

[bnott]

What I was referring to was that it asked me for the admin password before it would do the upgrade, and the password I use worked.

I'll try to uinstall\reinstall. Given the other posts on the forum, you may want to consider putting a note next to the download that you can't upgrade, and that a fresh install is required.

Brian

[jcstites]

I had the same problem with an upgrade from 3.5.1 to 4.0. After the upgrade, I tried to hit the admin page but was told that my credentials were invalid (both for admin and for a user account I had in 3.5). The only thing I can find is that the users table in the 3.5.1 sgvault database has been moved to the sgmaster database. However, the table in the sgmaster database has no users in it.

As a temporary workaround, I added a new record to the users table in sgmaster with login=admin, copying the encrypted password from the 3.5 database and pasting it into the password column for the new user. I also set the securityrights column to 7 (I think it uses a bitwise comparison for certain rights, 7 containing the admin rights). After this, I could log in to the admin site and add users.

I say this is temporary because I don't know if this is the same as having the built-in admin user or if it's just a new named-user. I also don't know yet if the new users I create will be linked up to existing checkouts and revision histories contained for the files in my source database. But it gets me up and running for now until some hotfixes come out that clean up this mess.

[Beth]

We're still looking into this.

bnott--- You never mentioned whether a reinstall took care of it. If it hasn't send an email.

jcsites--is there any chance that you have a Vault server log with errors in it?

The best solution for both is to send log files (sgvault.log), a copy of your web.config, and vault_install.log to support at sourcegear.com (attn: Beth) with a link to this post. The log files are located in the Windows temp directory and the web.config is in the Vault virtual directory.

[bnott]

The complete uninstall (leaaving the database) and reinstall seems to have fixed it. Of course, per the other thread, I'm still working on getting the client installed to connect to it : ).

Brian

[dmaidlow]

Has there been any work around found for this? I'm having the exact same problem. I've got a 5 user license, and after the upgrade no one can connect via the client, and the admin cannot login to the admin interface.

I do have log files with errors. would you like them?

[dmaidlow]

ok, well i *think* i resolved the problem. I revisited the error log and noticed a permission denied error for sgvaultuser in the master database.

I added sgvaultuser to the master database with public and db_owner. This allowed me to login to the web admin interface and update my keys.

Once they keys were updated my clients could also login.

Please let me know if you find any other steps that i might need to run.

thanks
darrin

[Beth]

Currently, I'm still having users uninstall and reinstall as the solution for this issue

[pcuce]

During the installation it asked for the admin password, which I put in. I assume it checked it against the database during the installation. But when I try to log into the admin web page it says username or login incorrect.

[dmaidlow]

pcuce - i resolved that problem on my end by adding the sgvaultuser to the sgmaster database in SQL server - giving that account both public and db_owner rights.

after i did that i could login with my administrator password

[pcuce]

Did you create a login too? If so, how did you do it?

[dmaidlow]

I'm talking about SQL server users here. The sgvaultuser user existed in SQL server already. I only needed to give the user access to the sgmaster database.

To do this, start up SQL enterprise manager, or SQL management studio depending on which version of SQL server you're running. Going from memory here but it should be close - connect to your server, find your sgmaster database in the tree. Expand that and click on users. You should be able to right click and choose add user or something to that effect. select the sgvaultuser user from the dropdown, and click the boxes beside public and db_owner

hope that helps.

[pcuce]

Do you mean that the login existed already and you created a user for the sgmaster database?

I don't have an sgvaultuser as either a login or a user in any of the vault databases.

I guess I'll try a reinstall. Thanks for your help.

[pcuce]

I uninstalled and reinstalled but never get past a certain point. Here's the error: