Vault database on different server?

If you are having a problem using Vault, post a message here.
Post Reply
c17
Posts: 6
Joined: Wed Jan 23, 2019 5:43 pm

Vault database on different server?

Post by c17 » Tue Jun 04, 2019 1:50 pm

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
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Re: Vault database on different server?

Post by jclausius » Tue Jun 04, 2019 2:23 pm

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
Jeff Clausius
SourceGear

c17
Posts: 6
Joined: Wed Jan 23, 2019 5:43 pm

Re: Vault database on different server?

Post by c17 » Tue Jun 04, 2019 2:38 pm

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
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Re: Vault database on different server?

Post by jclausius » Tue Jun 04, 2019 2:56 pm

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
Jeff Clausius
SourceGear

c17
Posts: 6
Joined: Wed Jan 23, 2019 5:43 pm

Re: Vault database on different server?

Post by c17 » Wed Jun 05, 2019 11:07 am

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
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Re: Vault database on different server?

Post by jclausius » Wed Jun 05, 2019 11:43 am

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?
Jeff Clausius
SourceGear

Post Reply