Installing Vault on a new server

[klemeje]

Hello,

I'm currently using Vault Standard (5.0.1.18729) installed on server 2003 and using a different 2003 server running sql2005 to host the databases.

We are moving to new servers and moved the databases to a 2008R2 server running sql2005, and I'm attempting to install the same version of vault on a 2008R2 server. When I get past the part of asking to keep the existing database, to which I select yes, I get a window stating "Checking the installed database version...OK. Creating SourceGear master database schema...CREATE DATABASE persmission denied in database 'master'.

Any idea on what is wrong or what I'm missing?

Thanks

[Beth]

Will the Vault server and the databases be on the same server or will they be on different servers?

Are you connecting to SQL using Windows authentication or SQL authentication?

If you're using Windows authentication, do you have administrator level access to SQL?

[klemeje]

Vault server and databases will be on different servers, both are server 2008r2. We are using sql authentication with an account I created in sql with dbo rights on the sgmaster and sqvault databases.

[Beth]

The SQL account you use during the install needs to have full SQL admin rights. Vault won't use what you login with to run the databases. Vault will create its own user and give it db_owner rights.

You need to either give your SQL user that you log in as full admin rights or login as 'sa'. If you use 'sa' to login, then you don't need that other account you created.

[klemeje]

Thanks for the help, I made the sql acct I created serveradmin rights and the install completed.

[Beth]

Thank you for the update. I'm happy to hear you're working.