Open Remote Desktop
Connect to AZ-SQL
Open PowerShell as Administrator
Run the following script that can be found here: c:\temp\new self signed cert v1.ps1
Put your curser in the first line and run only this line:
New-SelfSignedCertificate -CertStoreLocation cert:\LocalMachine\my -dnsname AZ-SQL.lkeeley.com -NotAfter (Get-Date).AddMonths(60)
The result of this line must be entered in line 4 of the script following the LocalMachine\My\
Once updated with the new thumbprint, highlight the remaining lines (2-5) and run these.
$pwd=ConvertTo-SecureString "vzCFN2qBtnlLQiL" -asplainText -force
$file="C:\temp\SQLcertificate.pfx"
Export-PFXCertificate -cert cert:\LocalMachine\My\051B3C3D3490C377FD3986E4A6E1B374903044B6 -file $file -Password $pwd
Import-PfxCertificate -FilePath $file cert:\LocalMachine\root -Password $pwd
*You can update the password in line 2 between the quotes each time you need to generate one.
Now that you have the Self-Signed Cert, go to C:\temp\SQLcertifcate.pfx and double click to install.
Select Local Machine, Click Next.
Click Yes
Click Next
Type/Paste in the password from line 2 of the script. Click Next
Select Place all certificates in the following store and click browse
Choose Personal. Click Ok.
Click Next.
Click Finish.
Click on Start Menu, go to Microsoft SQL Server Reporting, Open Report Server Configuration Manager
Click Yes
Click Connect
Click on Web Service URL
Click on the HTTPS Certificate dropdown and select the certificate you just created.
Click Apply
Click on Web Portal URL
Click Advanced
Under the HTTPS section, click ADD, choose your cert you just created.
Click Ok
Click Exit.
Test URLs on your local machine