Setup Windows SQL

1. Log alle aanmeld acties van gebruikers

   1. You can enable connection logging. For SQL Server 2008, you can enable Login Auditing. In SQL Server Management Studio, open SQL Server Properties > Security > Login Auditing select "Both failed and successful logins".

   Make sure to restart the SQL Server service.

2. Logging bekijken via browser

   1. Toegang tot log folder
      1. Ga naar C:\Program Files\Microsoft SQL Server\MSSQL{n}\MSSQL
      2. Eigenschappen/Beveiliging
      3. Voeg toe gebruiker IUSR met lees rechten

openssl pkcs12 -export -out cert.pfx -inkey private.key -in cert.crt -certfile CACert.crt
rem openssl pkcs12 -export -out aliconnect_nl.pfx -inkey aliconnect_nl.key -in __aliconnect_nl.crt -certfile __aliconnect_nl.ca-bundle
pause

OpenSSL> x509 -x509toreq -in __aliconnect_nl.crt -out aliconnect.csr -signkey aliconnect.key