Admin password changed after 4.1.1 update

infinition · 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 · 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 · 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

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.

infinition · 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...

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.

infinition · 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?

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.

infinition · 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)

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?

infinition · 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"?

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.

infinition · 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 · 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 · Post by **infinition** » Tue Apr 29, 2008 7:50 am

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