Vault Installation issue

[colinwaite]

We are installing Vault 3.0.6 onto a new server.

Despite having a previous DB sgvault backup, initially we attmepted to install the application from scratch.
We get quite far, enerting admin password and SQL server details.
This fails during installing the stored procedures when an issue with "a column name was ambiguous with a name of 'name'" occurs.

To work around this we restored our existing DB backup and attemped to install again.
Get as far as entering the SA User/password and DB name and instllation and clicking install, enter yes to keep existing DB. We get the following error message:
"Ensuring that sgvaultuser has access to the Vault database...Password validation failed. The password does not meet Windows policy requirements because it is too short. Vault Setup is exiting due to a failure or cancellation. Error Code = -1280"

Is the issue occuring as we are now using SQL2005 (as opposed to SQL2000?
The installation utility creates the sgvaultuser, does it do this and break the Windows policy requirements for passwords?

Happy to receive a solution to either of the problems.
Preferrably the first issue as we seem to get most of the way through the install until there is an issue with a valut SP with an ambiguous column name of 'name'.

Many thanks in advance.

[colinwaite]

Hello again.

Reinstalled using SQL2000 and everything installed just fine.
Obviously, the additonal valiation within SQL2005 is causing my issues.

I need to look to upgrade my version of Vault.

[lbauer]

I'm not sure why you got the error on the "scratch" Installation. However, we usually recommend that you have the Vault database in place before you run the installer, if you are moving the database or upgrading. If you would like further help with this, send us a copy of the Vault_install.log file from the temp directory of the user who installed Vault. E-mail it to support at SourceGear.com with a link to this post.

Re: password policies errors in SQL Server 2005 -- this is configurable. See this Microsoft link for more information:

http://msdn.microsoft.com/en-us/library ... L.90).aspx

If you are using SQL Server authentication during the installation, the password for the sgvaultuser is the same as the Vault admin password which you created during installation. You could try creating a Vault admin password that fits the requirements for password policies as indicated in the Microsoft information.