Unable to log into Vault - Could not load connect string

[sgailey]

All users where having a problems logging on to Vault this morning.
IIS was running and users would enter a user/pass but there was an
internal error displayed and no Vault. I stopped then restarted ISS
and users were then able to use the Web and Clients. We would like to
better understand the error and how to prevent it in the future.

I am including a section of the sgvault.log file showing the error.
User rPatel had been running builds all morning until the errors. Our Vault
install is older but we did just hand-off a large VSS last Thursday. Things
have been working well until this morning.

We are running VaultPro 5.1.2
Vault Server is running MS Windows Server 2008 (64bit)
IIS 7.5
Two Xeon processors
12 GB ram

Thanks
Stuart Gailey

Code: Select all

Normal Vault Log above this point

----12/5/2013 8:31:31 AM     PRoberts--<Computer name and IP data>--SSL Disabled	ASMX: GetCheckOutListChanges finished. 
----12/5/2013 8:34:49 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure started. 
----12/5/2013 8:34:49 AM     rPatel--<Computer name and IP data>--SSL Disabled	Getting repository Structure-> Rep ID: 11 Base: 11498 Target: -1 
----12/5/2013 8:34:49 AM     rPatel--<Computer name and IP data>--SSL Disabled	Could not load connect string.  There is probably an error with the encrypted password for the sgvaultuser database user.  Contact technical support at http://support.sourcegear.com 
----12/5/2013 8:34:49 AM     rPatel--<Computer name and IP data>--SSL Disabled	Vault Failed to establish a connection to the database. 
----12/5/2013 8:34:49 AM     rPatel--<Computer name and IP data>--SSL Disabled	FailDBConn 
----12/5/2013 8:34:49 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure finished. 
----12/5/2013 8:34:50 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure started. 
----12/5/2013 8:34:50 AM     rPatel--<Computer name and IP data>--SSL Disabled	Getting repository Structure-> Rep ID: 11 Base: 0 Target: -1 
----12/5/2013 8:34:50 AM     rPatel--<Computer name and IP data>--SSL Disabled	Could not load connect string.  There is probably an error with the encrypted password for the sgvaultuser database user.  Contact technical support at http://support.sourcegear.com 
----12/5/2013 8:34:50 AM     rPatel--<Computer name and IP data>--SSL Disabled	Vault Failed to establish a connection to the database. 
----12/5/2013 8:34:50 AM     rPatel--<Computer name and IP data>--SSL Disabled	FailDBConn 
----12/5/2013 8:34:50 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure finished. 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure started. 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	Getting repository Structure-> Rep ID: 11 Base: 11498 Target: -1 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	Could not load connect string.  There is probably an error with the encrypted password for the sgvaultuser database user.  Contact technical support at http://support.sourcegear.com 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	Vault Failed to establish a connection to the database. 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	FailDBConn 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure finished. 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure started. 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	Getting repository Structure-> Rep ID: 11 Base: 0 Target: -1 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	Could not load connect string.  There is probably an error with the encrypted password for the sgvaultuser database user.  Contact technical support at http://support.sourcegear.com 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	Vault Failed to establish a connection to the database. 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	FailDBConn 
----12/5/2013 8:35:04 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure finished. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure started. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	Getting repository Structure-> Rep ID: 11 Base: 11498 Target: -1 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	DB: GetUserRepositoryLastChange started. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	DB: GetUserRepositoryLastChange finished. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	DB: GetLatestRepositoryInfo started. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	DB: GetLatestRepositoryInfo finished. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	TreeManager: cache matches repository revision and folder security hasn't changed.  Returning cached tree, revID 11498 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	DB: GetLastTreeSecurityChange started. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	DB: GetLastTreeSecurityChange finished. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	VaultServiceAPI::GetRepositoryTreeDelta() UserID:12 RepID:11 Base:11498 Target:11498  Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	ASMX: GetRepositoryStructure finished. 
----12/5/2013 8:35:53 AM     rPatel--<Computer name and IP data>--SSL Disabled	GetRepositoryStructure returned: Success 

[lbauer]

Sgvaultuser is the database user that Vault Server uses to connect to SQL Server.

The Vault installer uses the Vault Admin password for the sgvaultuser password when you install Vault.
The installer encrypts the sgvaultuser password in the Vault Service web.config file then stores the encrypted password information to the registry in HKEY_LOCAL_MACHINE\SOFTWARE\SourceGear\Vault Server or HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SourceGear\Vault Server (64-bit).

We've seen this error before because of a mismatch between the registry information the information in the database or web.config. The user usually has to make some manual changes, reinstall, etc.

In your case, an IIS reset fixed it, so it's hard to say what happened. Was the sgvaultuser password changed temporarily in the database? Could the registry have been temporarily unavailable to the Vault Server?

If it's working now, your registry settings and database info appears to be in sync.

[sgailey]

We have not made any changes to the account info for admin in Vault. No changes to any system account MS SQL or Vault for that matter. The server has not been reboot or updated in the past week. The logon issue reappeared again this morning, no one was able to log in. A restart of the IIS server fixed the problem again.

[Beth]

Update: User has contacted us and we will take this discussion offline.

HS: 229227