Upgrade 10.0 -> 10.0.1

[ajj3085]

I'm trying to update from 10.0 to 10.0.1. During the install, I didn't notice the SQL server dialog and just hit OK. I had transitioned from the default instance of SQL to a named one (SQL 2008 -> 2014 Express). The connection failed, and I was prompted again but unable to change the server, only give login information.

So I canceled, which did a rollback, which actually was more of an uninstall. I tried running the installer again, this time giving it the correct SQL instance name. It finds the DB, but fails to update it saying it couldn't add the NETWORK SERVICE account. It then uninstalls everything. This is the error in the log:

Code: Select all

Log started at 17 Oct 2017 - 14.33.55

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

FileVersionInfo: File:             C:\inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
InternalName:     CustomActionExe.exe
OriginalFilename: CustomActionExe.exe
FileVersion:      10.0.1.793
FileDescription:   
Product:          
ProductVersion:   10.0.1.793
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\VaultPro\ 
	/WEBDAV=C:\inetpub\wwwroot\SgDav\ 
	/PARAMS=
	/DROPDB=
	/UPGRADE=
	/ADMINPW=
	/SQLSERVER=
	/WINAUTH=1
End commandline args.

Found local name of NT AUTHORITY\NETWORK SERVICE for Network Service account.
See if we need to do an upgrade or an install...Configuring your new Vault Standard Installation
Entered CreateCryptoRegistryValues.
CreateCryptoRegistryValues completed successfully.
Found SOFTWARE\Wow6432Node
Requesting the IIS Process User...
Found local name of NT AUTHORITY\NETWORK SERVICE for Network Service account.
Modifying VaultAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying VaultShadowFolderAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying VaultIndexAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying VaultNotifyAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying SgDavAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Classic
Creating Applications in IIS for web services...
VaultService application created.
Creating Applications in IIS for VaultShadowFolder web services...
VaultShadowFolder application created.
Creating Applications in IIS for Find in Files Index web services...
VaultIndexService application created.
Creating Applications in IIS for Notification web services...
VaultNotificationService application created.
Creating Applications in IIS for SdDav web services...
SgDav application created.
Creating Virtual Directories...
VaultService Virtual Directory created.
VaultShadowFolder Virtual Directory created.
VaultIndexService Virtual Directory created.
VaultNotificationService Virtual Directory created.
SgDav Virtual Directory created.
Exit SetInstallationSettings() success
Entered GetServerBindings()
	Subkey is open
Exit GetServerBindings()
Requesting 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...	User is trying to install to Microsoft SQL version 12.0.5556.0
OK
Checking for existing databases...Found.
Asking for database's fate...Keep existing.
Upgrading the existing source control database...
This may take a long time. Do NOT stop this process!
	Checking the installed database version... 10.0.0.2
OK
Putting sgvault database in SINGLE_USER mode.
getting the collation of the current source control database
the Vault database has the collation SQL_Latin1_General_CP1_CI_AS
Upgrading existing database user information with a new install.
	Login used is: NT AUTHORITY\NETWORK SERVICE
The stored procedure to grant a Windows Login database access failed.  User does not have permission to perform this action.
The user, NT AUTHORITY\NETWORK SERVICE, could not be added as a SQL Server login.  Please verify the windows account exists on this machine. 

Note, on some database collations check the case of the user's name.
Vault Standard Setup is exiting due to a failure or cancellation. Error Code = 902
The user, NT AUTHORITY\NETWORK SERVICE, could not be added as a SQL Server login.  Please verify the windows account exists on this machine. 

Note, on some database collations check the case of the user's name.
Vault Standard Setup is exiting due to a failure or cancellation. Error Code = 902ExitCode on exit: 902

The server is W2k8R2, with SQL Server 2014 Express.

[Beth]

Is the SQL Server on the same machine as the Vault server or on a different machine?

During the upgrade, it would have been filled with the same SQL Server used previously. Are you trying to switch SQL Servers? If not, open SQL Server Management Studio and check each one to see which one holds sgvault and sgmaster.

[ajj3085]

Is the SQL Server on the same machine as the Vault server or on a different machine?

During the upgrade, it would have been filled with the same SQL Server used previously. Are you trying to switch SQL Servers? If not, open SQL Server Management Studio and check each one to see which one holds sgvault and sgmaster.

The SQL Server is on the same machine I'm installing Vault on. I'm not trying to switch SQL servers, I had already done that with Vault 10.0 a few months ago. The same server was running SQL 2008R2 and I installed SQL 2014 Express and moved the DB. Vault was working fine after that move. I think the upgrade had the old server location though, and I had already uninstall SQL2008R2.

I can see all the databases on the 2014 named instance, and it was working with Vault 10. The only change I'm trying to make now is updating to the latest Vault version. The logs find the DB, but something goes wrong trying to upgrade it.

[Beth]

Run a command prompt as administrator and then launch the installer from there. That can help with adding permissions even to SQL.

[ajj3085]

Run a command prompt as administrator and then launch the installer from there. That can help with adding permissions even to SQL.

I tried that, it didn't help.

I tried installing the Vault server on my workstation, and if I add domain\myworkstation$ as a sysadmin to the DB server, it updates the database and installs somewhat successfully (for some reason the CSS files don't seem to be found so the web UI is not really usable).

I've also tried logging in as a different user on the server, but the installation fails with the same message after checking the DB version.

[Beth]

Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread so that we can work out taking a closer look?

[ajj3085]

Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread so that we can work out taking a closer look?

Done. Also, trying to install Vault 10.0.0 also fails with the same error.

[Beth]

Email received.

HS: 249241

[ajj3085]

Beth worked with me, and we granted db_owner to NETWORK SERVICE for all vault related DBs, and ran the MSI from an admin command prompt. That resolved the issue.

[Beth]

Thanks for updating.