I have created a certificate authority on my Linux server using OpenSSL. I have added that certificate authority to the
Windows Trusted Root Certificate Authorities, which it now recognises.
What do I need to do, from this point, to create a valid SSL certificate that SQL Server will recognise and be able to use? Assuming that my CA key is named
root.key, its certificate named
root.pem, and its equivalent certificate signing request named
No guide / tutorial has been able to tell me this. Every guide seems to be concerned with using the database server to create a certificate authority and generate keys, or something or other - I do not want this. All I want is for my Linux server to generate the SSL certificates, and for those certificates to be used by my client database machines (possibly without going through Microsoft Management Console and other unnecessarily complicated bullsh*t), such that I can connect to them via TCP/IP from my Linux machine (it can connect fine when using no encryption). The computer running the MSSQL server is not part of a domain, and its computer name / hostname is
WORKSTATION (if this matters at all).