use gMSA account to login to SQL Server Management studio

Question

Hi All

gMSA account can be configured as a service account for SQL Server service. Is there a way to
use gMSA account to login to SQL server using SQL Server management studio like other SQL server users?

Some articles like shown below are using gMSA as sysadmin user. But I am not able to find an article from microsoft website.

https://cloudiqtech.com/windows-2016-docker-containers-using-gmsa-connect-to-sql-server/

Thanks
Guru

Answer 1

Hi,

Q&A currently supports the products listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can reach the experts in the dedicated SQL Server forum over here:
https://social.technet.microsoft.com/Forums/en-US/home?category=sqlserver

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon

Answer 2

Hi,

There is no way to use gMSA to login manually as you can't provide gMSA password manually.

Answer 3

On the server that is registered to retrieve the gMSA password (-PrincipalsAllowedToRetrieveManagedPassword Parameter for the New-ADServiceAccount command; check with "Get-ADServiceAccount gmsa-name -Properties *") use Sysinternals psexec:
PsExec.exe -u domain\gmsa-name$ -i "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Ssms.exe". If psexec asks for a password just hit enter.