open ms sql connection using gMSA

Question

Hello everyone,

trying to connect to ms sql and run Select Getdate(),DB_NAME(),USER_NAME() for testing

I have two machines, ComputerA(SQL Engine) and ComputerB(Power Automate Desktop)

i started with

step 1: create KDS root Key..

step 2: create Security Groups (gMSA-DW) and add the computers required (for testing this will be ComputerA and ComputerB)

step 3 : create gMSA

Power shell command New-ADServiceAccount -Name qssq02 -DNSHostName qssq02.domain.com KerberosEncryptionType AES256 -PrincipalsAllowedToRetrieveManagedPassword gMSA-DW 

then in power automate (ComputerB) trying to open the connection and my connection string looks something like this (not sure if its correct)

Provider=SQLNCLI11.1;User ID=domain\qssq02$;Password=;Initial Catalog=TestDB;Data Source=ComputerA;

in Summary, the above approach didn't work and wandering if it's possible? also during step 3 is -ServicePrincipalNames required?