Provisioning sanitized data with SQL Clone and Data Masker. Watch now.

Assign permissions to gMSA

jpomfretjpomfret Posts: 1 New member
Hi folks,

I'm looking to automate a refresh process. A windows schedule task will run weekly to start/stop application services and run the SQL Clone image\clone creation processes. We want to use a gMSA for this task - are these supported for SQL Clone permissions?

On this page it only mentions AD Users and groups:
User roles - SQL Clone 5 - Product Documentation (red-gate.com)
Version 2.2.0 of SQL Clone introduced role-based permissions. These allow administrators to assign Active Directory users or groups into specific roles, enabling them to control who can do what with SQL Clone. These permissions apply on both the web UI and via PowerShell or other clients.
Thanks
Jess
Tagged:

Answers

  • Eddie DEddie D Posts: 1,726 Rose Gold 5
    Hi Jess,
    Thank you for your forum post.

    Sadly, SQL Clone has not been officially tested using gMSA - see the 'Untested scenarios' section of this help limitations document

    By all means please to give it a try.

    You may need to initially, need to provide a Windows AD account for the SQL Clone Service and SQL Clone Agent accounts.  Once up and running, switch the two services to use a gMSA.  However this has not been tested.

    Many Thanks
    Eddie


    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.