Admin password changed after 4.1.1 update

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Admin password changed after 4.1.1 update

Post by infinition » Thu Apr 24, 2008 11:04 am

Hi,

I just installed 4.1.1 over 4.0.2. I chose to keep my databases and used the same admin password I was using before when prompted in the 4.1.1 installation.

Now, I can't login with the admin user.
Weird stuff.... Help please!

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Thu Apr 24, 2008 12:55 pm

oh and I tried 3 times. I even did this:
- uninstall everything;
- reinstall 4.0.2;
- logged as 'admin' without a problem;
- installed 4.1.1;

The same again. My admin password stops working. Can it be a database corruption or something?

Please, I have a whole company waiting for Vault to be back online...
Thanks.

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Thu Apr 24, 2008 1:54 pm

Ok I tried to install 4.1.0 first in order to upgrade to 4.1.1 from there and guess what, another problem.

This (below) appears when I try to access the Admin login Web page.


Server Error in '/VaultService' Application.
--------------------------------------------------------------------------------

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'VaultService.Global'.

Source Error:


Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="VaultService.Global" %>



Source File: C:\inetpub\wwwroot\VaultService\global.asax Line: 1


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2379; ASP.NET Version:1.1.4322.2379

jeremy_sg
Posts: 1821
Joined: Thu Dec 18, 2003 11:39 am
Location: Sourcegear
Contact:

Post by jeremy_sg » Fri Apr 25, 2008 3:46 pm

What is your server on? The Could not load type 'VaultService.Global' error indicates that it may not be finding one of the dlls that it needs.
Subscribe to the Fortress/Vault blog

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Mon Apr 28, 2008 8:28 am

hum, it's running on a Win Server 2003 with SQLEXPRESS on the same machine.

But why is my 4.0.2 version working perfectly and not 4.1.x? New DLLs?

- If I install from scratch 4.1.x, I get the loading error.
- If I upgrade from 4.0.2 to 4.1.x, for some reason my admin password gets corrupted...

jeremy_sg
Posts: 1821
Joined: Thu Dec 18, 2003 11:39 am
Location: Sourcegear
Contact:

Post by jeremy_sg » Mon Apr 28, 2008 8:34 am

Another thing that you may need to do is to set the app pool for Vault to use the 2.0 .net framework, as that's required by 4.0 and 4.1.
Subscribe to the Fortress/Vault blog

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Mon Apr 28, 2008 9:21 am

not sure what you mean by that. Could you provide a link or procedure please?

jeremy_sg
Posts: 1821
Joined: Thu Dec 18, 2003 11:39 am
Location: Sourcegear
Contact:

Post by jeremy_sg » Mon Apr 28, 2008 9:37 am

On the server, open the IIS manager, and open the Properties dialog on the VaultAppPool.

In the ASP.Net tab, select 2.0 from the dropdown.
Subscribe to the Fortress/Vault blog

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Mon Apr 28, 2008 10:02 am

Ok, now the page is loading. Unfortunatly, I'm stuck with the password problem.

I just installed it again, carefully entered twice (confirmation) my admin password and I can't log in.

Is there a way to reset the password in the database table?

The login I'm trying is: "admin" (without the quote)

jeremy_sg
Posts: 1821
Joined: Thu Dec 18, 2003 11:39 am
Location: Sourcegear
Contact:

Post by jeremy_sg » Mon Apr 28, 2008 10:08 am

Can you check your Vault server log file to see if there's any helpful error messages?
Subscribe to the Fortress/Vault blog

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Mon Apr 28, 2008 10:16 am

ok, I found the problem with the log file (wish I knew it existed hehe)

----28/04/2008 12:02:28 PM admin--eserver.Intranet.Infinition.com(127.0.0.1)--SSL Disabled System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'spgetlogininfo', database 'sgmaster', schema 'dbo'.

What are the required permissions, in addition to "Connect" and "Execute"?

jeremy_sg
Posts: 1821
Joined: Thu Dec 18, 2003 11:39 am
Location: Sourcegear
Contact:

Post by jeremy_sg » Mon Apr 28, 2008 10:17 am

The account that is connecting to the database should be a dbowner of sgmaster.
Subscribe to the Fortress/Vault blog

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Mon Apr 28, 2008 10:49 am

hum.. here's what I have:

In 4.0.2 (which is working great)
- sgmaster owner: (domain)\Administrator
- sgmaster user: NT AUTHORITY\NETWORK SERVICE with only the "Connect" permission
- sgvault: same thing.

After installing 4.1.1, the settings remain the same, but now I have the error mentionned in the previous post. When installing, for both versions, I always selected the option NT AUTHORITY\NETWORK SERVICE for loggin and my SQL server is configured to user Windows Authentication.

So, what do I need to do?

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Post by Beth » Mon Apr 28, 2008 3:30 pm

NT Authority/Network Service and <machine name>/ASPNET need to have db_owner permissions.

If some sort of schema is configured for those user names, you won't want that and will want to delete the schema.

Is this database on the same server or a different server than the Vault server?

You can always feel free to write to support at sourcegear.com (attn: Beth), with a link to this forum thread, as well and I can take a more direct look.

infinition
Posts: 26
Joined: Fri Apr 27, 2007 8:13 am

Post by infinition » Tue Apr 29, 2008 7:50 am

e-mail sent. Yes it is on the same machine.

Locked