Create SQL Server SSL
I want to create a SQL Server SSL certificate on my Windows Server 2016, and I followed the steps shown in this Youtube video https://www.youtube.com/watch?v=m7ONeACYBdE&t=182s
In the video the presenter publish this PowerShell line:
New-SelfSignedCertificate -CertStoreLocation Cert:\LocalMachine\My -DnsName host.doman.com -KeySpec KeyExchange -FriendlyName SQLCer
Unfortunately the presenter didn't explain whether something should be changed in this line or whether it is generic, so when I use it on my PowerShell, it create the certificate but in the next step, when I need to select it in the Protocols Window (in the configuration Manager), the certificate in the "drop down" list is empty.
I used the PowerShell line exactly as I wrote it above, do I need change something in this line ? Is the certificate missing because of that or it's something else ?
According to your question of the part to be modified, you need to change the "DnsName" host.doman.com and replace it with your dns name
According to SQL Server SSL certificate please check the following URL for the steps
- What is the fastest\best way to get file names from a folder using PowerShell?
- Collections and the Powershell Pipeline
- How to fix/speed up powershell script?
- Extracting specific data from a string with regex and Powershell
- Encryption PowerShell script generated by SQL Server Management Studio executes but doesn't work
- How do I assign values to variables in PowerShell ThreadJobs?
- Running 7-Zip from within a Powershell script
- Powershell extract custom line numbers using Get-Content
- Read individual key presses in PowerShell
- Set-PnPListItem Column '{my column name}' does not exist. It may have been deleted by another user
- Security Warning when running scripts - Unblock-File not unblocking file
- What is an equivalent of *Nix 'cut' command in Powershell?
- PowerShell equivalent to grep -f
- Multiple foreground colors in PowerShell in one command
- Pipe complete array-objects instead of array items one at a time?
- How to return a parameterized code block in PowerShell
- Writing a secret from AzureKeyVault in a Azure DevOps Pipeline to a file with powershell
- Change the default terminal in Visual Studio Code
- Syntax error when executing Invoke-DDBQuery to fetch dynamodb record using Powershell
- Is it possible to open a Windows Explorer window from PowerShell?
- The mock in my pester test keeps calling Connect-AzAccount
- qwinsta /server:somesrv equivalent in Powershell?
- Shortcut to pull up all file explorer windows that are open
- Convert Unix time with PowerShell
- How to extract a substring from EDL line, between 2 sequence of characters
- Querying nested JSON files in Powershell
- How to create string of foreach results
- Powershell get timezone with DST
- How to replace all Active Directory account photos?
- Variable in WPF Binding with PropertyChanged