Vault database on different server?

[c17]

Is it possible to have the actual Vault database on a separate server from that hosting the Vault Web application?

That is:
Machine A (Web server only) hosts Vault server application
Machine B (SQL Server only) hosts Vault databases

If so, how is that set up?

Thanks

[jclausius]

Yes. That configuration is possible. The key will be the method of connectivity between the Vault Server and SQL Server. The easiest thing is to configure SQL Server for SQL Server authentication, and provide that during installation.

If you use Windows (or trusted) authentication, both the Vault Server and SQL Server must be on a domain and a Domain based is used to run the various Vault Server Application Pools so they will be granted access to the SQL Server. This is a more advanced configuration, and may require a tweak at the end for the "Identity" of the Process Model in each application pool.

Some of this is outlined in the Vault Server installation guide:

https://www.sourcegear.com/vault/docume ... abase-Auth

And for Windows authentication, see steps A - D here - viewtopic.php?t=188

[c17]

Ah, thank you. We can use SQL authentication.

This is not a new installation; we already have Vault running on machine A, and we want to move just the databases to machine B. There's a FAQ detailing which databases to move, which is clear; but is there a simple way to reconfigure Vault to point to the new databases? Or would it be simpler to just re-install Vault (and then replace the starter databases with our current ones)?

[jclausius]

Note, if you replace, you would need to do it BEFORE reinstalling a Vault Server, as the permissions of a restored database would be incorrect.

Some of that information is covered in this KB article regarding Moving the Vault databases - viewtopic.php?t=924

[c17]

I've studied the instructions in the KB about moving Vault databases, but we want to move the databases to the Azure SQL Service. You can't backup/restore or attach/detach with that service; instead, you have to use the SSMS task "Deploy database to Azure SQL database".

Would the instructions be basically that same using that task?

[jclausius]

TBH, I couldn't tell you. This is an unsupported configuration in that we've never tried. Most Azure configurations that I'm aware of end up using SQL Server installed on a Windows Azure virtual machine.

Does the Azure Deploy allow you to copy in all stored procedures and user functions?