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.
Trying to install vault on SQL Server 2019 Express Fails
Moderator: SourceGear
Re: Trying to install vault on SQL Server 2019 Express Fails
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
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
Re: Trying to install vault on SQL Server 2019 Express Fails
Thanks Tonya - I will try as explained then get back to you. Might be tommorow now as it's afternoon in the UK now.
Re: Trying to install vault on SQL Server 2019 Express Fails
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.
I need to spend time looking into this.
Re: Trying to install vault on SQL Server 2019 Express Fails
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.
i'm not sure which file it is looking for is missing.
However attempting to log on using the vault client fails. The error text is given in the attached error.txt file.
i'm not sure which file it is looking for is missing.
Re: Trying to install vault on SQL Server 2019 Express Fails
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
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