updating vault 10.0.0 to 10.0.2

If you are having a problem using Vault, post a message here.
Post Reply
pmaurice
Posts: 3
Joined: Fri Apr 05, 2019 1:44 pm

updating vault 10.0.0 to 10.0.2

Post by pmaurice » 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?

Tonya
Posts: 866
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: updating vault 10.0.0 to 10.0.2

Post by Tonya » 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

pmaurice
Posts: 3
Joined: Fri Apr 05, 2019 1:44 pm

Re: updating vault 10.0.0 to 10.0.2

Post by pmaurice » 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.

Tonya
Posts: 866
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: updating vault 10.0.0 to 10.0.2

Post by Tonya » 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

pmaurice
Posts: 3
Joined: Fri Apr 05, 2019 1:44 pm

Re: updating vault 10.0.0 to 10.0.2

Post by pmaurice » Fri May 03, 2019 8:10 am

Hello Tonya,

the administrator nuance as done the trick.

Thanks for the help.

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Re: updating vault 10.0.0 to 10.0.2

Post by jclausius » Mon May 20, 2019 3:37 pm

Glad to see the elevated admin prompt worked.
Jeff Clausius
SourceGear

Post Reply