Install / SQL Access

nemoby · Post by **nemoby** » Wed Mar 12, 2008 2:38 pm

We are about to install Vault using different Web and SQL servers. Our team controls the web servers and the SQL DBAs control the SQL servers. All kinds of loops will be required for us to gain SA access to the SQL server (frankly, something that will adds days to the install).

The install docs state:

>>>
If you choose to use SQL Server Authentication in the SQL Server Setup portion of the installation, then the installer will use the user/password you supply in the SQL Server Setup page to log into SQL Server. That username you supply must have SQL Server administrative privileges (the SA account, for example). The Server installation will then create the sgvault database, plus create a SQL login named 'sgvaultuser', and grant it access to the sgvault database.
<<<

Is there anyway that a non SA account can be used to do the install? We can get an account that has rightw to create dbs and we can get the runtime SQL account and password created ahead of time.

Options?

Thanks,

lbauer · Post by **lbauer** » Wed Mar 12, 2008 2:49 pm

If you're using SQL Server authentication, then you need an account in the SQL Server setup portion of the installation that can create the Vault databases (sgmaster and sgvault in Vault 4.x) and create the login for the Vault database user, sgvaultuser. The account doesn't need to be specificall SA, though it needs similar SA rights. Note that this account is only used during the installation of Vault, not during Vault operations.

nemoby · Post by **nemoby** » Wed Mar 12, 2008 2:56 pm

Linda,

Can we use an account other than sgvaultuser? My guess is that the DBAs are going to insist on some different naming convention.

-Andy

nemoby · Post by **nemoby** » Wed Mar 12, 2008 3:13 pm

Linda,

Looks like we have a workaround on this end. Thanks for your help...

-Andy

lbauer · Post by **lbauer** » Wed Mar 12, 2008 4:35 pm

Thanks for the update.