Installation Problem

matt_x · Post by **matt_x** » Sat Nov 11, 2006 12:53 pm

Hi,

I am trying to do a fresh install Vault Server 3.5.1 (Single User). The setup is always failing with the following error:

Vault log started at 11 Nov 2006 - 18.50.50

Custom action assembly location: C:\inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
Custom Action version: 3.5.1

FileVersionInfo: File: C:\inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
InternalName: CustomActionExe.exe
OriginalFilename: CustomActionExe.exe
FileVersion: 3.5.1.4786
FileDescription:
Product:
ProductVersion: 3.5.1.4786
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...Checking if this machine is a domain controller
Domain Controller check returned False
IIS Process Model user: MATT\ASPNET
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
Checking if this machine is a domain controller
OK
Verifying the SQL Server requirements... User is trying to install Vault to Microsoft SQL version 8.00.760
OK
Checking for an existing Vault database...Not found.
Creating a new Vault database on (local)...
Using collation: SQL_Latin1_General_CP1_CI_AS
Making sure we don't have a user login still hanging around.
Executing commands in vault_ddl.sql
Read vault_ddl.sql from our resources.
Creating the SourceGear Vault database...OK
DoSqlCommandsFromFile completed successfully.
Executing commands in vault_upgrade.sql
Read vault_upgrade.sql from our resources.
Upgrading SourceGear Vault database...CreateDatabase Error2: Database option 'ANSI nulls' does not exist.
Database option 'ANSI padding' does not exist.
Database option 'ANSI warnings' does not exist.

Vault Setup is exiting due to a failure or cancellation. Error Code = 402
Database option 'ANSI nulls' does not exist.
Database option 'ANSI padding' does not exist.
Database option 'ANSI warnings' does not exist.

Vault Setup is exiting due to a failure or cancellation. Error Code = 402ExitCode on exit: 402

I did try the following from the forums:

SELECT
DATABASEPROPERTYEX('sgvault', 'IsAnsiNullsEnabled') AS [ANSI_NULLS],
DATABASEPROPERTYEX('sgvault', 'IsAnsiPaddingEnabled') AS [ANSI_PADDING],
DATABASEPROPERTYEX('sgvault', 'IsAnsiWarningsEnabled') AS [ANSI_WARNINGS],
DATABASEPROPERTYEX('sgvault', 'IsArithmeticAbortEnabled') AS[ARITHABORT],
DATABASEPROPERTYEX('sgvault', 'IsNullConcat') AS [CONCAT_NULL_YIELDS_NULL],
DATABASEPROPERTYEX('sgvault', 'IsQuotedIdentifiersEnabled') AS [QUOTED_IDENTIFIER],
DATABASEPROPERTYEX('sgvault', 'IsNumericRoundAbortEnabled') AS [NUMERIC_ROUNDABORT]

... and everything seems ok. I cannot find any other info about this issue; indeed a very strange one. Your help will be greatly appreciated.

System:
* Windows XP (SP2)
* SQL Server 2000 (SP3)

Thanks,
- Matt

lbauer · Post by **lbauer** » Sun Nov 12, 2006 12:16 pm

What were the result when you ran the Select Database Property query in this post?

http://support.sourcegear.com/viewtopic.php?t=5527

If they didn't match the result in the post, try running this query:

EXEC sp_dboption @dbname = 'sgvault', @optname = 'ANSI nulls', @optvalue = 'on'
EXEC sp_dboption @dbname = 'sgvault', @optname = 'ANSI padding', @optvalue = 'on'
EXEC sp_dboption @dbname = 'sgvault', @optname = 'ANSI warnings', @optvalue = 'on'
EXEC sp_dboption @dbname = 'sgvault', @optname = 'arithabort', @optvalue = 'on'
EXEC sp_dboption @dbname = 'sgvault', @optname = 'concat null yields null', @optvalue = 'on'
EXEC sp_dboption @dbname = 'sgvault', @optname = 'quoted identifier', @optvalue = 'on'
EXEC sp_dboption @dbname = 'sgvault', @optname = 'numeric roundabort', @optvalue = 'off'

matt_x · Post by **matt_x** » Sun Nov 12, 2006 1:34 pm

hey...

I actually did try that it is actually exactly the same with the expected result. so it seems that something else is going very weird...

any suggestions? it fails even after trying to re-install it over the failed setup (it detects the existing copy, asks for drop, and fails in both conditions).

matt_x · Post by **matt_x** » Sun Nov 19, 2006 4:51 pm

*any* suggestions?
i guess no one has a clue on this

lbauer · Post by **lbauer** » Sun Nov 19, 2006 9:15 pm

Any possiblility that you have more than one instance of SQL Server installed and one is configured correctly, but not the other?

matt_x · Post by **matt_x** » Tue Nov 21, 2006 5:23 am

Not really... It is single server with only 1 instance.
that is why this is so weird; things seem to be correct... and it still fails at the ANSI!?...