Wednesday 23 September 2020

Creating self signed SSL certificate and configuring SSL in Tomcat

"C:\Program Files\Java\jdk1.8.0_241\bin\keytool" -genkey -keyalg RSA -noprompt -alias tomcat -dname "CN=localhost, OU=NA, O=NA, L=NA, S=NA, C=NA" -keystore keystore.jks -validity 9999 -storepass changeme -keypass changeme

 

Then  in server.xml add


<Connector port="443" protocol="HTTP/1.1" SSLEnabled="true"
               maxThreads="150" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS"
            keyAlias="tomcat" keystoreFile="C:\Program Files\Java\jdk1.8.0_231\bin\keystore.jks" keystorePass="changeme"/>

Thursday 10 September 2020

After Windows restart SQL server developer edition login stops working on ASP.Net app

 For some reason SQL Server authentication (mixed mode) is disabled on SQL Server Developer Edition so have to enable it. And for some reason all the grants to the user have to reapplied.