use gMSA account to login to SQL Server Management studio

Thanakodi, Guru Prashanth 61 Reputation points
2020-05-27T07:42:26.793+00:00

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,282 questions
0 comments
Accepted answer
  1. Leon Laude 85,666 Reputation points
    2020-05-27T07:43:43.883+00:00

    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

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Suman Bhowmik 76 Reputation points
    2020-11-26T14:40:54.367+00:00

    Hi,

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

    0 comments