updating vault 10.0.0 to 10.0.2

If you are having a problem using Vault, post a message here.

Posts: 3
Joined: Fri Apr 05, 2019 1:44 pm
PostPosted: Fri Apr 05, 2019 1:59 pm
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?

Posts: 481
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear
PostPosted: Fri Apr 05, 2019 3:22 pm
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

Posts: 3
Joined: Fri Apr 05, 2019 1:44 pm
PostPosted: Mon Apr 08, 2019 12:15 pm
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.

Posts: 481
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear
PostPosted: Mon Apr 08, 2019 2:35 pm
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

Posts: 3
Joined: Fri Apr 05, 2019 1:44 pm
PostPosted: Fri May 03, 2019 8:10 am
Hello Tonya,

the administrator nuance as done the trick.

Thanks for the help.

Posts: 3599
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
PostPosted: Mon May 20, 2019 3:37 pm
Glad to see the elevated admin prompt worked.
Jeff Clausius
SourceGear

Return to Support (Vault Professional)

Who is online

Users browsing this forum: No registered users and 1 guest