SQL Server SSL Certificate List Blank

by ServerSSL

Eliminating the Issue with SQL Server SSL Certificate List Blank

SQL SSL certificates play a very important role in ensuring the safety of the clients’ sensitive information on your business website. Thus, it is highly important that online business owners configure a dependable SQL server SSL certificate to facilitate encryption of confidential information, preventing threats like identity theft, malware attacks and other fraudulent activities. Although the installation of SSL certificates is quite easy there can be instances wherein you have to deal with SQL server SSL certificate list blank. With this, you need to be familiar on how you can get out of this installation issue so that you can proceed with the process with much ease.

Save up to 90% Now on Go Daddy SSL Certificates!

Why It Is Possible To Have a Blank List or Empty Menu

If you have tried installing SQL SSL certificate in the past you may had encountered having an empty drop down menu as you try to configure the certificate. This may leave you clueless on what to do next so you need to know the certain things that may be causing SQL server SSL certificate blank list which are as follows:

  • The SQL server may be included in a domain that had CA installed partially enabled.
  • The web services were not configured.
  • There was non-use of SQL Cluster.

How to Resolve the Issue?

Resolving the SQL server SSL certificate list blank issue is quite easy and you just have to follow these detailed instructions:

Make the Request for Certificate on SQL Server

  • Launch the MMC console and put in the certificate snap-in.
  • Double click on “Personal” folder and choose “All Tasks” then “Make Custom Request” and proceed with Next.
  • Choose “No Enrolment Policy”, click Next.
  • Choose “No Template” while leaving the rest of the values at default settings, click Next.
  • Select the small down arrow button to reveal other properties then choose “Properties”.
  • Type in the server name ensuring proper capitalization.
  • Leave description empty and add appropriate values in the Subject tab.
  • Add key encipherment in all application policies.
  • Change the value to signature on the private key section.
  • Lastly, select Ok and proceed with Next.
  • Include a file name and select Finish.

After, creating the request for SSL, the next thing that you need to do in order to resolve the issue with blank list SQL server SSL certificate is to begin processing the CSR. All you need to do to accomplish this is to copy the file generated from the CA server and support the request. Afterwards, you must get the binary file and copy it to the SQL server.

The next thing that you have to do is to import the SSL into the certificate store and instruct the SQL server regarding which SSL certificate to use which will eliminate the problem with SQL server SSL certificate list blank so you do not have to deal with the empty dropdown again. The entire process may be tedious but by observing the following processes you will be assured of a successful installation of the SQL server SSL certificate.


SQL Server SSL Certificate List Blank – Eliminating the Issue

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: