Could not load connect string

[Albert]

As I am trying to deploy vault server to a remote machine. (Note: my vault user login name is not sgvaultuser, but sgvault99 instead, because the sql login name is enforced to contain numerics on the remote machine.)

Then I got the following error:

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

[Albert]

I have got around with the login password problem. But now I am having another problem to transfer the stored procedured and user functions to the remote SQL Server. As the error said " Encrypted object is not transferrable".

[jclausius]

The Vault database cannot be transferred through DTS or replication. You'll need to detach / backup the sgvault database, and attach / restore on the remote machine.