SQL Server & Source on different machines

tsnow · Post by **tsnow** » Thu Feb 21, 2008 7:11 am

Currently we have all of our SQL instances on one machine and source on another. My question is can I install vault on the machine that has the source and point it to the SQL server to install the database portion on that machine?

lbauer · Post by **lbauer** » Thu Feb 21, 2008 11:55 am

Yes, this is supported. If SQL Server is on a different machine, you need to use SQL Server authentication in the SQL Server setup portion of the installation, or --

If you wish to use Windows Authentication, use a custom account (domain account) in the IIS Process Model portion of the installation.

tsnow · Post by **tsnow** » Mon Feb 25, 2008 9:55 am

Since I have two different machine one with source and one with SQL which machine needs to have IIS installed? I was thinking it would be the machine with SQL but I wanted verification.