updating vault 10.0.0 to 10.0.2

[pmaurice]

Hello Vault Support Forum,

I am trying to upgrade vault 10.0.0 to 10.0.2.
My database is set.
During installation i enter everything login/pass and I accept to re-use the same database.

The installation crash :
Upgrading the existing source control database...
This may take a long time. Do NOT stop this process!
Found 'Auto Create Statistics' ON for sgmaster -- setting it to OFF...User does not have permission to alter database 'sgmaster', the database does not exist, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed.
Vault Professional Setup is exiting due to a failure or cancellation. Error Code = -1280

We tried few things , change permission of users and it does not work.

Any idea?

[Tonya]

Hello,

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

Did the account you used to connect to the SQL Server have SQL sysadmin rights? The rights need to be at the same level as 'sa'.

Thanks,

Tonya

[pmaurice]

I used "Machine (IIS AppPool)" and "Windows Authentication" to connect. The Installer detects that I already have a database on the server and asks if I want to keep it. I click Yes to continue and I get the error listed in my first message. I am using SQLExpress and I am no expert with SQL. How do I check if SQL server has SQL sysadmin rights? How do I check if the rights are at the same level as 'sa'? Those are probably basic questions, but again my experience with SQL is very limited.

Thanks for the help.

[Tonya]

Hello again,

If you are unsure if the user you are specifying has SQL Server admin rights, you could try running a command prompt as administrator (right-click and select Run As Administrator) and then use the command:

msiexec /i "path to the Vault installer/vault installer name"

Replace "path to the Vault installer/vault installer name" with the correct information. This should increase your user rights.

Tonya

[pmaurice]

Hello Tonya,

the administrator nuance as done the trick.

Thanks for the help.

[jclausius]

Glad to see the elevated admin prompt worked.