Failure of logging in after sg database move

[dpbouchard]

I successfully detached and reattached my sgvault, sgmaster databases, ran the sql script to set up security, successfully installed the SG Server but when I try to login, it fails with the following log file:

# SourceGear Vault Server
----7/28/2009 1:26:04 PM --()-- 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
----7/28/2009 1:26:04 PM --()-- Vault Failed to establish a connection to the database.
----7/28/2009 1:26:04 PM --()-- 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
----7/28/2009 1:26:04 PM --()-- Vault Failed to establish a connection to the database.
----7/28/2009 1:26:04 PM --()-- 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
----7/28/2009 1:26:04 PM --()-- Vault Failed to establish a connection to the database.
----7/28/2009 1:26:05 PM --()-- 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
----7/28/2009 1:26:09 PM --SERVER012.packrat.local(10.0.0.20)--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
----7/28/2009 1:26:09 PM --SERVER012.packrat.local(10.0.0.20)--SSL Disabled Vault Failed to establish a connection to the database.
----7/28/2009 1:26:34 PM admin--SERVER012.packrat.local(10.0.0.20)--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
----7/28/2009 1:26:34 PM admin--SERVER012.packrat.local(10.0.0.20)--SSL Disabled Vault Failed to establish a connection to the database.
----7/28/2009 1:26:45 PM admin--SERVER012.packrat.local(10.0.0.20)--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
----7/28/2009 1:26:45 PM admin--SERVER012.packrat.local(10.0.0.20)--SSL Disabled Vault Failed to establish a connection to the database.
----7/28/2009 1:27:17 PM sa--SERVER012.packrat.local(10.0.0.20)--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
----7/28/2009 1:27:17 PM sa--SERVER012.packrat.local(10.0.0.20)--SSL Disabled Vault Failed to establish a connection to the database.
----7/28/2009 1:27:34 PM administrator--SERVER012.packrat.local(10.0.0.20)--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
----7/28/2009 1:27:34 PM administrator--SERVER012.packrat.local(10.0.0.20)--SSL Disabled Vault Failed to establish a connection to the database.
----7/28/2009 1:32:11 PM administrator--SERVER012.packrat.local(10.0.0.20)--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
----7/28/2009 1:32:11 PM administrator--SERVER012.packrat.local(10.0.0.20)--SSL Disabled Vault Failed to establish a connection to the database.
----7/28/2009 1:35:47 PM --desktop5000-35.packrat.local(10.0.0.201)--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
----7/28/2009 1:35:47 PM --desktop5000-35.packrat.local(10.0.0.201)--SSL Disabled Vault Failed to establish a connection to the database.
----7/28/2009 1:35:58 PM admin--desktop5000-35.packrat.local(10.0.0.201)--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
----7/28/2009 1:35:58 PM admin--desktop5000-35.packrat.local(10.0.0.201)--SSL Disabled Vault Failed to establish a connection to the database.

Any thoughts?

[lbauer]

We got your email to support and will respond soon.

[lbauer]

The user is installing on a 64-bit operating system. There is a problem with SQL Server authentication and 64-bit machines.

The Crypto Keys in the registry SQL auth needs to decrypt the password are being put in the wrong hive for some reason.

There are a couple of ways you can get around this:

- Export the SourceGear\Vault (or Fortress) Server registry key from the 64 bit hive and import it into the WOW6432 hive. To do this open RegEdit and export HKLM\Software\SourceGear\Vault Server to a .reg file, open the .reg file in notepad, change the registry paths to the wow6432node then and import it to HKLM\Software\WOW6432Node\SourceGear\Vault Server (or you can just copy and paste the values from one place to the other).

- Uninstall and Re-install using Windows Authentication.

See this forum post for more details

http://kb.sourcegear.com/FortressHelp/v ... f=5&t=9815