Trying to install vault on SQL Server 2019 Express Fails

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
kmxsoft
Posts: 47
Joined: Mon Sep 14, 2015 12:34 pm

Trying to install vault on SQL Server 2019 Express Fails

Post by kmxsoft » Thu Oct 24, 2024 11:02 am

I've done this successfully many times - but i guess that Microsoft may have changed something in the current 2019 downloaded from MSDN. This appears to affect both the 32bit and 64bit server installations.

Everything proceeds okay until the Vault installation wants to make changes to SQL Server - at which point SQL Server advises that the user doesn't have permission to make that change.

Although the Vault installation will probably need to be updated to solve this, I'd be happy to use a syntax command to do this - I would be grateful if someone could advise the command so that I can complete the installation.

The full text of the error is attached.
syntax.txt
(1.9 KiB) Downloaded 17 times

Tonya
Posts: 908
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: Trying to install vault on SQL Server 2019 Express Fails

Post by Tonya » Fri Oct 25, 2024 7:07 am

Vault 10.x supports SQL Server 2019 Express and the issue appears to be permission related. My suggestion is to run the installer from a command prompt as admin.

Run a command-prompt as administrator. Change directories to the location of the Vault client and run the command:
msiexec /i "vault installer name.msi"
Replace "vault installer name.msi" with the correct installer name.

Let me know if this doesn't help.

Tonya

kmxsoft
Posts: 47
Joined: Mon Sep 14, 2015 12:34 pm

Re: Trying to install vault on SQL Server 2019 Express Fails

Post by kmxsoft » Fri Oct 25, 2024 8:24 am

Thanks Tonya - I will try as explained then get back to you. Might be tommorow now as it's afternoon in the UK now.

kmxsoft
Posts: 47
Joined: Mon Sep 14, 2015 12:34 pm

Re: Trying to install vault on SQL Server 2019 Express Fails

Post by kmxsoft » Fri Oct 25, 2024 10:59 pm

I installed the server as adminstrator - that went well but at the end it wouldn't connect to the server via a browser.

I need to spend time looking into this.

kmxsoft
Posts: 47
Joined: Mon Sep 14, 2015 12:34 pm

Re: Trying to install vault on SQL Server 2019 Express Fails

Post by kmxsoft » Mon Oct 28, 2024 9:36 am

Vault Pro installed okay after following the instructions, a cursory glance at the data folder shows the expected vault database files have been created.

However attempting to log on using the vault client fails. The error text is given in the attached error.txt file.
error.txt
(5.14 KiB) Downloaded 12 times
i'm not sure which file it is looking for is missing.

Tonya
Posts: 908
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: Trying to install vault on SQL Server 2019 Express Fails

Post by Tonya » Mon Oct 28, 2024 12:11 pm

Hello again,

This is likely an IIS related issue. When you setup / configured the IIS server for the Vault Server, did you add the "Application Server" feature as well as the HTTP static content to the role?

Below are the roles that need to be checked:

Web Server (IIS) \ Web Server \ Common HTTP Features \ Static Content ( checked) Web Server (IIS) \ Web Server \ Application Development \ ASP.NET 4.6 (checked or whatever version you have installed)

Please let me know if this doesn't resolve the problem.

Thanks,

Tonya

Post Reply