Skip to main content
commvault.com commvault.com
Solved

associate admin center credential manger to sql plan

D
Byte
Forum|alt.badge.img+13

Hello team

 

We have a group in commcell to hold sql credentials → client computer groups→ sql→ group properties→ advanced settings tab→ override higher levels settings → impersonate user → select the credential that we created in commcell credential manager. By doing this, any sql client in this group will inherit this particular service account that used for sql level backup/restore rather than set cred for each sql client.



After upgrade to the latest release 2022E , we now have the option credential manager on Command center and the existing credentials have been auto-created by upgrade for sql credential manager support.

 

I’m trying to associate the credential in command center to a sql plan, and unable to find the option(override higher levels settings\impersonate user) in the plan. 

 

wonder if there is a way to associate the credential to any sql plan on command center?

 

 

 

Best answer by MFasulo

Its not set on the plan but on the server group (just like Java UI)

 

Go to manage > server groups > click “server group”

Go to configuration tab and at the bottom you will see a tile for “SQL server authentication”

Click “override high level settings”

Unclick “Use Local System account” and a dialog box will appear with all the credential manager users

Select the appropriate one.

 

 

View original
    Did this answer your question?

    6 replies

    D
    Byte
    Forum|alt.badge.img+13
    • DanC
    • Author
    • Byte
    • 104 replies
    • October 4, 2022

    I found it

    this will need to create a server group in the command center first ->add a rule to associate servers with the specific plan → once group created, navigate to config tab→ sql server authentication → toggle ‘override higher levels settings’→ enable impersonate 

    MFasulo
    1 person likes this
    • MFasulo
      MFasulo
    D
    Byte
    Forum|alt.badge.img+13
    • DanC
    • Author
    • Byte
    • 104 replies
    • October 4, 2022

    this thread can be closed

    MFasulo
    Vaulter
    Forum|alt.badge.img+12
    • MFasuloVaulter
    • Vaulter
    • 175 replies
    • Answer
    • October 4, 2022

    Its not set on the plan but on the server group (just like Java UI)

     

    Go to manage > server groups > click “server group”

    Go to configuration tab and at the bottom you will see a tile for “SQL server authentication”

    Click “override high level settings”

    Unclick “Use Local System account” and a dialog box will appear with all the credential manager users

    Select the appropriate one.

     

     

    D
    1 person likes this
    • D
      DanC
    D
    Byte
    Forum|alt.badge.img+13
    • DanC
    • Author
    • Byte
    • 104 replies
    • October 4, 2022

    thanks @MFasulo 

    to use cred manager in command center, i will have to create a server group then i’m able to use sql server authentication

     

    MFasulo
    Vaulter
    Forum|alt.badge.img+12
    • MFasuloVaulter
    • Vaulter
    • 175 replies
    • October 4, 2022
    DanC wrote:

    thanks @MFasulo 

    to use cred manager in command center, i will have to create a server group then i’m able to use sql server authentication

     

    Only if you want to apply it to several SQL servers.   Otherwise if you go to the instance level you can use the saved credentials in credential manager.     This is especially powerful as you can provide privileged users “access" to use the saved credentials and allow the backup admin to apply these creds without have to reveal the username and password, but enable self-service. 

    D
    1 person likes this
    • D
      DanC
    D
    Byte
    Forum|alt.badge.img+13
    • DanC
    • Author
    • Byte
    • 104 replies
    • October 4, 2022

    thank you very much @MFasulo 

     

    MFasulo
    1 person likes this
    • MFasulo
      MFasulo

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings