Man, I can't thank you enough. I was using PowerShell to run dbatools commands and it was giving me an error when I run any command because of a certificate trust issue. It's been resolved thanks to you.
This was an informative, well-delivered video. I am very familiar with the PowerShell scripting program, and following his instructions to the letter allow me to get a working cert so I can could use my developer edition of SQL server. One caution I want to add, however. Please note use the PowerShell edition with IntelliSense so you don't have to write out those long string names for the commands is Windows Powershell ISE. You want to run that as Admin and not the other shell.
Thanks for making this video.. it's really informative.. just one concern.. I have NT Service\MSSQLSERVER as login account for SQL service.. so do I have to give explicit permission to it or it works if SYSTEM group has full control?
Man, I can't thank you enough. I was using PowerShell to run dbatools commands and it was giving me an error when I run any command because of a certificate trust issue. It's been resolved thanks to you.
Happy it worked for you!
I'm still having problems how are you connecting to your instance (without providing your laptop or instance name) thanks.
This was an informative, well-delivered video. I am very familiar with the PowerShell scripting program, and following his instructions to the letter allow me to get a working cert so I can could use my developer edition of SQL server. One caution I want to add, however. Please note use the PowerShell edition with IntelliSense so you don't have to write out those long string names for the commands is Windows Powershell ISE. You want to run that as Admin and not the other shell.
Thank You.. Following your steps in the recording, i was able to enable SSL in SQL2019
Thanks for making this
Good job!👍
Thanks for making this video.. it's really informative.. just one concern.. I have NT Service\MSSQLSERVER as login account for SQL service.. so do I have to give explicit permission to it or it works if SYSTEM group has full control?
How does it goes with SQL server always on AG , can you create a video on that please or share any document
Hello Mughees! you can export the same certificate to other AlwaysOn nodes. Watch this whole series on how to import a certificate.
Is there a way to make this Self-Signed certificate issued to CA Internal server as a trusted certificate?
Thanks!
excellent.. I am stuck on migration