After Install! Could not load connect string

If you are having a problem using Fortress, post a message here.

Moderator: SourceGear

Post Reply
garyld
Posts: 7
Joined: Wed Dec 12, 2007 8:24 am

After Install! Could not load connect string

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" />
<!-- INTEGRATEDWINDOWSMODE-add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='true'; Server=AAAIIS\SQLEXPRESS; Database=sgvault; Integrated Security='true'" />INTEGRATEDWINDOWSMODE- -->
</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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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
Posts: 7
Joined: Wed Dec 12, 2007 8:24 am

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
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

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
Posts: 7
Joined: Wed Dec 12, 2007 8:24 am

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

This solution did not work, I have the same issue

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

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
Posts: 7
Joined: Wed Dec 12, 2007 8:24 am

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.

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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.
Jeff Clausius
SourceGear

garyld
Posts: 7
Joined: Wed Dec 12, 2007 8:24 am

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.

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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.
Jeff Clausius
SourceGear

garyld
Posts: 7
Joined: Wed Dec 12, 2007 8:24 am

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

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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.
Jeff Clausius
SourceGear

garyld
Posts: 7
Joined: Wed Dec 12, 2007 8:24 am

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

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

Post Reply