Lately when I set up a Microsoft SQL server I’ll always implement SSL and a gMSA account to run SQL from.
Why? Convince yourself reading this blog post.
Because this post focuses on a specific issue, I’ll not explain implementing SSL as such. Here’s the Microsoft documentation I follow for my implementations:
This is initially made for SQL 2000, but all buttons and clicks are still the same.
However, the first time I’ve tried combining a gMSA for SQL and configure SSL, SQL wouldn’t start anymore.
In my troubleshooting process I’ve tried the following:
- Remove the SSL configuration from SQL: SQL started
- Tried a whole bunch of certificates because the suggestion the ‘common name’ in the certificate was wrong.
- Grant the gMSA account the Windows Administrator role: SQL started with SSL configuration.
After this last step I’ve concluded that the issue must be rights related. Which was actually a good thing. Rights can be added, I knew where to look.
A few troubleshooting hours later I came up with the solution.
Here’s what you need to do:
Give the gMSA account read acces on the private key of your certificate stored in the certificate store of the computer account.
Enjoy your secure connections and all nights without worrying that accompany it…
If you like some extra reading material on how to use gMSA accounts: