Error installing Vault Server

[lefty]

Trying to install the Vault server on a Windows 2003 server that's also the SQL server, running SQL Server 2000. I can reproduce it on a Windows 2000 domain controller as well.

I get to the dialog that asks for the SQL server address, login, and password... I've tried both (local) and the machine's actual IP address.

If I put in a bogus login, it fails with "login failed for user 'foo'.", but when I enter the correct info (my SA login), the install crashes with an error 250.

I've tried passing the relevant arguments to the MSI file when I launch it (such as sqlserver=(ip address) etc), but it doesn't seem to make any difference.

I'm attaching the text of the vault_install.log file:

Vault log started at 8 Jul 2005 - 16.28.14

Custom action assembly location: C:\Inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
Custom Action version: 3.0.7

FileVersionInfo: File: C:\Inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
InternalName: CustomActionExe.exe
OriginalFilename: CustomActionExe.exe
FileVersion: 3.0.7.2863
FileDescription:
Product:
ProductVersion: 3.0.7.2863
Debug: False
Patched: False
PreRelease: False
PrivateBuild: False
SpecialBuild: False
Language Language Neutral


The commandline args as passed in to us:

/TARGETDIR=C:\Inetpub\wwwroot\VaultService\
/TARGETDIR2=C:\Inetpub\wwwroot\VaultService\VaultShadowFolder\
/CUSTOMNAME=
/CUSTOMPW =
/PARAMS=
/DROPDB=
/UPGRADE=
/ADMINPW=
/SQLLOGIN=
/SQLPW=
/WINAUTH=
/SQLSERVER=
/IISPROCESS=0
End commandline args.

Found local name of NT AUTHORITY\NETWORK SERVICE for Network Service account.
Validate the target dir for shadow folders
See if we need to do an upgrade or an install...Configuring your new Vault Installation
Entered CreateCryptoRegistryValues.
CreateCryptoRegistryValues completed successfully.
Entered GetIISProcessUser.
Checking for IIS Version... IIS Process Model user: NT AUTHORITY\NETWORK SERVICE
GetIISProcessUser completed successfully.
Requesting Vault Admin user password... Hashing the admin pw
OK
Connecting to the SQL Server...ConnectToDatabase() completed successfully.
dialog result for uninstall is: OK
OK
Verifying the SQL Server requirements...Failed.
CheckSQLRequirements() failed: A severe error occurred on the current command. The results, if any, should be discarded.
Vault Setup is exiting due to a failure or cancellation. Error Code = 250
A severe error occurred on the current command. The results, if any, should be discarded.
Vault Setup is exiting due to a failure or cancellation. Error Code = 250ExitCode on exit: 250

Help!

[lefty]

This is with Vault Server 3.0.7, using VaultServer_3_0_7.msi, by the way

[lbauer]

Some things to verify:

Are you installing from the C: drive of the Vault server machine?

Do you have full administrative rights on the machine, plus rights to write to the registry?

Are you installing to a default instance or a named instance of MS SQL Server?

What service pack for SQL Server is installed?

Is SQL Server Authentication enabled in SQL Server?

Can you login to SQL Server using OSQL from a command prompt on the server machine? To log in as sa from the command line, type:

osql -U sa <enter> (you'll be prompted for a password)
>Password

[jclausius]

Linda's last question is on the right track. The Vault server installation requires an account that has administrative rights on the SQL Server. Check sql requirements also requires you to be able to use the master database.

Error 250 occurs when the Installer fails when running the following query:

USE [master]
GO
SELECT SERVERPROPERTY('ProductVersion')
GO

When you connect to the database with the login foo, can you run the same query?