Jump to content
Welcome to our new Citrix community!
  • 0

Upgrade VAAD database upgrade


Dennis Haschke

Question

Hi,

i have upgraded VAAD to V. 2311.
After the upgrade i startet my studio and select automatic database upgrade. My databases are hostet on a dedicated SQL 2022 server.
I try it with the SA user and with a domain user with the sysadmin role. I get the message that i have insufficient rights to upgrade the database.
Then i try it with the domin user i have used for the initial installation. That works for me.
But why not the SA user or the other domain user with sysadmin role in SQL?
All domain users are local administrators. The difference is only that the initial user who had worked for me is domain admin.

Regards
Dennis

Link to comment

6 answers to this question

Recommended Posts

  • 0
On 2/2/2024 at 4:12 PM, Dennis Haschke said:

I try it with the SA user and with a domain user with the sysadmin role. I get the message that i have insufficient rights to upgrade the database.

Does your domain user was part of security/login for all 3 citrix database ?

 

Link to comment
  • 0

Strange, I recently faced similar issue with same error i.e. insufficient rights though the id i was using for upgrade had sysadmin rights on SQL instance level.

Later i added the same id to all 3 databses   security-->users and provided dbowner & syadmin permission then upgrade went smooth without any error.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...