February 9, 2021 at 9:02 pm
Hello,
For a SCCM installation, we have been told we need to install a certificate. I am supposed to install it in configuration manager.
I go to the certificate tab. However, I don't see an import. I've looked up the internet and see where I should be seeing an import button. I am an admin on this database server.
However, I am not seeing the import button. Can anyone tell me how am I supposed to import a certificate?
Here is the article that I reviewed.
Certificate Management (SQL Server Configuration Manager) - SQL Server | Microsoft Docs
Here is what I am seeing.
Things will work out. Get back up, change some parameters and recode.
February 10, 2021 at 3:52 pm
Can't see your screenshot.
As an alternative you can import the certificate using the mcc certificate snapin
https://codekabinett.com/rdumps.php?Lang=2&targetDoc=create-install-ssl-tls-certificate-sql-server
It might be need to assign read permissions on the certificate in order to be selectable
First we need to find the name of the service account used by the instance of SQL Server. It will probably be something like ‘SQLServerMSSQLUser$[Computer_Name]$[Instance_Name]‘.
One way to do this is to navigate to the installation directory or your SQL Instance. By default SQL Server is installed at C:\Program Files\Microsoft SQL Server\MSSQL10_50.InstanceName.
Right click on the MSSQL folder and click Properties.
Click the Security tab and write down the user in the Group or user names window that matches the pattern of ‘SQLServerMSSQLUser$[Computer_Name]$[Instance_Name]‘.
Now, open the Microsoft Management Console (MMC) by click Start -> Run, entering mmc and pressing Enter.
Add the Certificates snap-in by clicking File -> Add/Remove Snap-in… and double clicking the Certificates item (Note: Select computer account and Local computer in the two pages on the wizard that appears.
Click Ok.
Expand Certificates (Local Computer) -> Personal -> Certificates and find the SSL certificate you imported.
Right click on the imported certificate (the one you selected in the SQL Server Configuration Manager) and click All Tasks -> Manage Private Keys…
Click the Add… button under the Group or user names list box.
Enter the SQL service account name that you copied in step 4 and click OK.
By default the service account will be given both Full control and Read permissions but it only needs to be able to Read the private key. Uncheck the Allow Full Control option.
Click OK.
Close the MMC and restart the SQL service.
February 10, 2021 at 7:29 pm
Oh my goodness thank you.
I have been trying various things to no end. I tried the snap in, but you outlined more steps.
Thank you so much. I am trying it now!!!
Things will work out. Get back up, change some parameters and recode.
February 11, 2021 at 9:42 am
Found one with a youtube movie https://joeschoice.com/sslandmssql/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply