Hi Tom. Don't fool stupid - it isn't an obvious setting. You do have to know it is there, and Microsoft could have done a much better of highlighting the changes. Phillip
Long explanation but there is no information for the disabling encryption. If you using CMS you coulnt make that setting one by one. You should disable encrytipn on Regedit.exe or etc.
This is great. While many of the options you described i already knew, what I didnt know was that SQL 2022 creates a self-signed cert by default. that explains the issue that I'm having. however, what i would like to know is cant we export the Self-signed SQL cert and add it to the trusted certs?
Hello Danny. Thank you for your question. Please see stackoverflow.com/questions/65836055/self-signed-certificate-cant-get-sql-server-client-to-trust-it . Phillip
Hello, I have done what was explained on the video but am still unable to connect. I now get an error “Login failed for user xxx Error 18456. User referenced is enabled. Can you assist?
Hi Galaxy. Thank you for your question. Please see learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error . Phillip
Thank you, I feel stupid not seeing this option previously!
Hi Tom. Don't fool stupid - it isn't an obvious setting. You do have to know it is there, and Microsoft could have done a much better of highlighting the changes. Phillip
I am lazy so i just got myself 19 version. Thank you
it helped me TQ
Long explanation but there is no information for the disabling encryption. If you using CMS you coulnt make that setting one by one. You should disable encrytipn on Regedit.exe or etc.
It Helped.. Thanks
This is great. While many of the options you described i already knew, what I didnt know was that SQL 2022 creates a self-signed cert by default. that explains the issue that I'm having. however, what i would like to know is cant we export the Self-signed SQL cert and add it to the trusted certs?
Hello Danny. Thank you for your question. Please see stackoverflow.com/questions/65836055/self-signed-certificate-cant-get-sql-server-client-to-trust-it . Phillip
Hello, I have done what was explained on the video but am still unable to connect. I now get an error “Login failed for user xxx Error 18456. User referenced is enabled. Can you assist?
bro thanks a lot that was very helpful
Thanks of lot i am try to this issue to solve last two days but solve
It still hasn't been resolved. Now, I'm facing a new error: 18456.
Hi Galaxy. Thank you for your question. Please see learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error . Phillip
Thank you man.
nope - it still blocks me to log in
it requires a change in server config to accept local win AND sql login. then a deep restart of the pc
thanks alot
thank you!
Thank you
eemmmmm
Thank you!