Problem after database move

[artcalek]

Hi,

Using Vault Standard Version 5.1.1.19215. Moved DB via backup and restore. Followed guidelines in post #3136 to change passwords after a DB move, but I get this error:

----7/18/2013 9:28:43 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
----7/18/2013 9:28:43 AM --()-- Vault Failed to establish a connection to the database.
----7/18/2013 9:28:43 AM --()-- System.NullReferenceException: Object reference not set to an instance of an object.
at VaultService.Global.Application_Start(Object sender, EventArgs e) at VaultService.Global.Application_Start(Object sender, EventArgs e)
----7/18/2013 9:28:43 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
----7/18/2013 9:28:43 AM --()-- Vault Failed to establish a connection to the database.
----7/18/2013 9:28:43 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
----7/18/2013 9:28:43 AM --()-- Vault Failed to establish a connection to the database.
----7/18/2013 9:28:43 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
----7/18/2013 9:28:43 AM --()-- Vault Failed to establish a connection to the database.
----7/18/2013 9:28:43 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
----7/18/2013 9:28:45 AM --ART-WIN7-64X(10.3.71.18)--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/18/2013 9:28:45 AM --ART-WIN7-64X(10.3.71.18)--SSL Disabled Vault Failed to establish a connection to the database.
----7/18/2013 9:28:45 AM acalek--ART-WIN7-64X(10.3.71.18)--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/18/2013 9:28:45 AM acalek--ART-WIN7-64X(10.3.71.18)--SSL Disabled Vault Failed to establish a connection to the database.

[Beth]

Are you using SQL authentication or Windows authentication for the SQL Server connection? Is that the same as it was before?

A fast way to get up and running would be to uninstall Vault, choose the option to keep the database and then install Vault again, but choose the option to reuse the database again.

[artcalek]

I believe that we are using SQL authentication there were specific user for "sgvaultuser" and "sourcegear". That said, I used my AD domain account to access thru the client.

As far as un/re install goes, I don't have the original installation package. Is a compatible version(5.1.1.19215) available?

Art.

[Beth]

Previous versions of Vault can be found on this page: http://www.sourcegear.com/vault/downloads2.html

[artcalek]

I'm not sure what to install. I only see Vault Client installations in the "Control Panel/Programs and Features" screen.

We have two "Servers" involved:

(1) SQL server with SGMASTER and SGVAULT databases
(2) a web server with three sites SgDav, VaultService and VaultShadowFolder.

Not sure where to start the un/install.

[Beth]

Prior to starting, make sure you have a current backup of your sgvault and sgmaster databases.

You'll uninstall Vault from the web server. If you don't see the Vault server there, then you might need to do a manual uninstall. If that's the case, then send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread, and we'll set up a meeting for me to help you with that.

During the uninstall you will be given the option to keep your database. Make sure you choose the option to keep your database.

For your installers, if you don't have them already, here are links to help.
Vault 32-bit server: http://download-us.sourcegear.com/Vault ... _19215.msi
Vault 64-bit server: http://download-us.sourcegear.com/Vault ... _19215.msi

[Beth]

I have received your email and will continue this discussion offline.

HS: 228358