MOving The Vault Database

[btd]

We are on Vault 5.1.1.19215 and SQL Server 2000 which has two databases SGVAULT and SGMASTER.

We wish to upgrader Vault by moving the existing database to a Windows Server 2008 which has SQL Server 2008 Standard Edition on it.

On the Application server, when we launch the Vault511.19125.msi to uninstall Vault, during one of th uninstall step - "Connect to SQL", we check the SQL Server authentication. Question 1When we do, DO WE HAVE TO USE THE SA ACCOUNT OR CAN WE USE A SQL ACCOUNT WE MADE THAT HAS FULL DBOWNER ACCESS TO Vault database?


Secpond question:
Back on the Application Server, and during the Install Vault Server Std Edition, we are again presented with a "Connect To SQL" step for the new database server. In this step, and like before we check the option for SQL Server Authentication. Question 2 When we do this do we have to use the SA account or can we use a SQL user we created? Note: This SQL user has DBOwner permissions for both SGVAULT AND SGMASTER and this is the user we'd like to use?

Do you see any problems is this approach?

Thanks

BTD

[Beth]

Prior to installing Vault you will need to make sure you restore the sgvault and sgmaster databases to the new SQL Server.

During the uninstall, if you want to remove the SQL databases, then you will need an admin level user to log in with. If you want to leave the databases there and remove them manually after the uninstall, then you can just press Cancel during the SQL connection string, and it will skip the SQL portion of the uninstall and uninstall just the Vault server.

During an install or upgrade, when connecting to the SQL server you will use the sa account or some SQL users that has administrator level rights. The connection is not for setting the user. With SQL authentication Vault creates its own user called sgvaultuser. Any account that has db_owner rights only has enough rights to run Vault once installed, but not enough rights to install or upgrade.

[btd]

Is it OK to uninstall and install Vault using the Windows Authentication method, thereby not using SQL method? Note: For us, the user logged in is a Domain Administrator.

Also, if I use Windows Authentication, will Vault creates its own user called sgvaultuser?

Thanks

BTD

[Beth]

If you mean that you want to use Windows authentication with just the SQL Server version, then that will work if the Vault server and the SQL Server are on the same machine. Vault will take a local machine account such as network service and make that the db_owner of the sgvault and sgmaster databases.

If the server are on different machines, then you will also need to run Vault under a domain account. That that involves is setting the IIS Process Model during the install to Custom and entering in the domain/domain user and the domain user's password. Then during the SQL connection, Vault will use that same domain user as the db_owner of Vault. If you go this route, the domain user does not need to be an administrator of anything. Vault will give that user just the bare minimum rights to the databases and Vault folders.

[btd]

Thanks

[Beth]

You're welcome.