Confluence on Windows with MSSQL Database Server and IIS.
Install confluence windows server with MSSQL database server. Use IIS as a proxy, Issue the Letsencrypt certificate for confluence using IIS. Troubleshooting of "The server selected protocol version TLS10 is not accepted by client preferences".
"The database collation 'SQL_Latin1_General_CP1_CI_AS' is not supported by Confluence". "Your database is must have the 'READ_COMMITTED_SNAPSHOT' option set to ON". Base URL update issue and Tomcat configuration error/warning while using the proxy.
0:00 - Intro.
0:30 - Introduction.
0:31 - MSSQL Server Database Installation and Network Service Configuration.
5:00 - Install Confluence
6:45 - Confluence MSSQL database setup
7:30 - Fixing the 'The driver could not establish a secure connection to SQL server by using secure socket layer (SSL) encryption. Error "The server selected protocol version TLS10 is not accepted by client preferences" error.
9:52 - Fixing the " The Database collation 'SQL_Latin1_General_CP1_CI_AS' is not supported by confluence error.
10:33 - Fixing the "your database must have the 'READ_COMMITTED_SNAPSHOT' option set to ON" error.
11:25 - Confluence MSSQL database setup and Configuration of confluence continue.
12:30 - Install Microsoft Web Server IIS.
13:53 - Install ARR(Application Request Routing) and URL Rewrite.
14:55 - Configure ARR (Application Request Routing).
15:13 - Creating a new site in IIS for confluence.
16:43 - Configure Request Filtering in IIS.
16:54 - Configure Output Caching in IIS.
17:10 - Create specific Windows Registery for Confluence.
18:01 - Configure URL Redirector for redirect confluence (Tomcat) requests to IIS.
19:36 - Create HTTPS site in IIS for Confluence using a self-signed certificate.
21:25 - Redirect HTTP request to HTTPS in IIS.
23:25 - Install Let's Encrypt module for windows and issue the certificate for confluence.
26:45 - Conclusion