After Install! Could not load connect string

garyld · Post by **garyld** » Wed Dec 12, 2007 8:27 am

I have installed 3 times each with the same error, below is the log and appsettings

<appSettings>
<add key="ConfigPath" value="C:\Inetpub\wwwroot\VaultService\Vault.config" />
<add key="BugTrackingPath" value="BTPBTPBTP"/>
<add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=AAAIIS\SQLEXPRESS; Database=sgvault; User ID=sgvaultuser; pwd=NfKpz/1N5LtiWFy0mQDbYaVn4x/aDW+R" />

</appSettings>

----12/12/2007 9:04:20 AM admin--aaaiis(192.168.2.117)--SSL Disabled Vault Failed to establish a connection to the database.
----12/12/2007 9:20:02 AM --()-- 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/12/2007 9:20:02 AM --()-- Vault Failed to establish a connection to the database.
----12/12/2007 9:20:02 AM --()-- 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/12/2007 9:20:02 AM --()-- Vault Failed to establish a connection to the database.
----12/12/2007 9:20:02 AM --()-- 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/12/2007 9:20:02 AM --()-- Vault Failed to establish a connection to the database.
----12/12/2007 9:20:02 AM --()-- The session information was not removed from the database. Please check sgvault.dbo.tblsessions within SQL Server. There may be orphaned sessions stored within the database. Error: FailDBConn
----12/12/2007 9:20:04 AM --aaaiis(192.168.2.117)--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/12/2007 9:20:04 AM --aaaiis(192.168.2.117)--SSL Disabled Vault Failed to establish a connection to the database.
----12/12/2007 9:20:20 AM admin--aaaiis(192.168.2.117)--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/12/2007 9:20:20 AM admin--aaaiis(192.168.2.117)--SSL Disabled Vault Failed to establish a connection to the database.

Beth · Post by **Beth** » Wed Dec 12, 2007 8:48 am

Give the recommendations from this thread a try and let me know the results: FailDBConn error after database restore
The first suggestion is to delete and recreate the sgvaultuser. Please note that it needs to be removed from the SQL server security section as well as the individual databases.
The second one is during the uninstall to delete the all references to the web service from IIS admin.

garyld · Post by **garyld** » Wed Dec 12, 2007 10:42 am

Ok, I have deleted the user and recreated and no luck. I replaced the user in the config with the sa user again no luck.

Beth · Post by **Beth** » Wed Dec 12, 2007 11:46 am

It appears the encryption for that user isn't quite right. It needs to be recreated, but let's let Vault recreate it instead. This only applies if you are connecting to the database during the install using SQL authentication. If you aren't connecting with that, then we're barking up the wrong tree.

If using SQL authentication, then uninstall the Vault server but keep the database. Then remove sgvaultuser from SQL. Then perform the install and let it create the sgvaultuser fresh itself.

garyld · Post by **garyld** » Wed Dec 12, 2007 4:10 pm

This solution did not work, I have the same issue

Beth · Post by **Beth** » Wed Dec 12, 2007 4:28 pm

We're still thinking is has to do with the encryption. To find out, try this....
In the web.config, for the connect string, change the pwd to password and put in the plain text password for admin.

If that works, then technically, you can run that way, but most prefer not to. That would seem to indicate that maybe the registry isn't getting the update it needs during a reinstall. In that case, you could uninstall, then check the registry for HKEY_LOCAL_MACHINE\software\SourceGear\Vault server and delete that key area. Or you could just clear all the Vault references out, but you would want to be cautious there so you don't accidentally delete your database files.

garyld · Post by **garyld** » Wed Dec 12, 2007 5:13 pm

That did not work. I gave up and used window auth.

Now I get this error from the client

The server uses a protocol that is not supported by this client.

My url is http://www.

Post by **jclausius** » Thu Dec 13, 2007 9:38 am

This is for Fortress, correct? Have you installed both a Fortress client and a Fortress server?

For a quick background on the original post, in regards to the encryption, the Crypto settings are stored within the registry and are unique for each installation. If you have moved an installation w/ out running the installation or "copied" over a password from a different file, the encryption on the connect string's password will fail.

garyld · Post by **garyld** » Thu Dec 13, 2007 10:38 am

I completely reinstalled fortress and can login to the web interface.

I cannot connect via the client. The error is

The server uses a protocol that is not supported by this client.

My url is http://www.

Post by **jclausius** » Thu Dec 13, 2007 11:29 am

This is very strange.

Let's try a couple of things:

1) Open a browser. Browse to http://www.

Please list the title and version number from there.

2) Open your Fortress client. Go to Help -> Technical Support. Please post the information listed in that dialog.

3) From your Fortress client log into fortressbeta.sourcegear.com. Use guest1 (user) and guest1 (pwd). Can you log in with your Fortress client? Finally, post the information from Help -> Technical Support.

garyld · Post by **garyld** » Thu Dec 13, 2007 1:03 pm

SourceGear Vault
Version 4.0.6.15954

SourceGear Fortress Client
Version 1.06 (15954)

I can connect to you server

Post by **jclausius** » Thu Dec 13, 2007 1:11 pm

Is the first entry from your server?

If so, it is for SourceGear *Vault*. For this to work, you'll need either a SourceGear *Fortress* Server or a SourceGear *Vault* client. Mixing of clients and servers will not work.

See http://www.sourcegear.com/fortress/downloads.html for the Fortress Server.

garyld · Post by **garyld** » Fri Dec 14, 2007 10:53 am

During one of my many reinstalls I inadvertently installed vault server.