v 4 upgrade failes to connect to SQL server

jfaria · Post by **jfaria** » Thu Jun 07, 2007 6:59 am

I just upgraded from 3.5 to 4 running on XP pro and SQL 2005. The installation seemed to run OK and after the install the webpage comes up to log in but the admin credentials are not accepted. I can log onto the server directly with the sgvaultuser credentials. I also uninstalled and restored my sql sgvault db, deleted the sgmaster db and tried the reinstall twice. I hope you can help

Thanks

The following is the log entry
----6/7/2007 8:34:38 AM --Laptop6.hq.faria.net(192.168.1.100)--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
----6/7/2007 8:34:38 AM --Laptop6.hq.faria.net(192.168.1.100)--SSL Disabled Vault Failed to establish a connection to the database.
----6/7/2007 8:34:38 AM joef--Laptop6.hq.faria.net(192.168.1.100)--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
----6/7/2007 8:34:38 AM joef--Laptop6.hq.faria.net(192.168.1.100)--SSL Disabled Vault Failed to establish a connection to the database.
----6/7/2007 8:34:58 AM --localhost(127.0.0.1)--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
----6/7/2007 8:34:58 AM --localhost(127.0.0.1)--SSL Disabled Vault Failed to establish a connection to the database.
----6/7/2007 8:35:07 AM admin--localhost(127.0.0.1)--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
----6/7/2007 8:35:07 AM admin--localhost(127.0.0.1)--SSL Disabled Vault Failed to establish a connection to the database.

Post by **jeremy_sg** » Thu Jun 07, 2007 7:56 am

Something has gone really wrong here. Can you look at your install log ( %TEMP%\vault_install.log for the user who did the install)? Also, look at your web.config to see if there are multiple connectStrings configured?

jfaria · Post by **jfaria** » Thu Jun 07, 2007 8:36 am

Thanks for the quick response. Here is the app settings from web.config. there are two entris but one is rem'd out. I could not find the vault_install.log as requested below. I searched the entire c drive and came up with nothing.

<appSettings>
<add key="ConfigPath" value="C:\Inetpub\wwwroot\VaultService\Vault.config" />
<add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=laptop6; Database=sgvault; User ID=sgvaultuser; pwd=YOb9btPkKvFfrQTjwhVHGA==" />

<add key="BugTrackingPath" value="C:\Inetpub\wwwroot\VaultService\VaultShadowFolder" />
</appSettings>

Post by **jeremy_sg** » Thu Jun 07, 2007 8:50 am

The vault_install.log file is in the TEMP directory of the user who did the install on the server machine. This might be faster to troubleshoot over the phone. Email me your phone number using the button below this post, and I will call you.