I'm installing Pega Platform 8.2 for the first time and I'm a little confused on the SQL configuration portion. I would like to use Pega best practices with dual-schema and dual-user configurations but I'm not familiar with creating schemas in SQL. Does anyone have a sql script that creates them per best practices?
I believe I've figured out the schema portion of this but the Windows auth vs SA still alludes me. The documentation doesn't reference Windows Authentication, only Kerberos, but kerberos is the default used in Windows Authentication so I'm assuming that's the route I need to go. But in the documentation it simply says to change the jdbc.custom.connection.properties value to include integratedSecurity=true. But when I do that, the installation fails stating "Database username must be specified".
Where do I specify the username and password for Kerberos authentication? And if so, that means I have to save the password in clear text in the setupDatabase.properties file?
You need to use command line when you are enabling Kerberos authentication.
For this you need to provide the value for jdbc.custom.connection.properties in the setupdatabase.properties and also include all the values of the database connection properties (which includes Database username).
Once you have provided all the values in the setupdatabase.properties file then use install.sh or install.bat script to start the installation and it will consider the setupdatabase.properties file to get the DB connection properties.
Please see the attached screen shot. This is what the documentation says for configuring the jdbc.custom.connection.properties. It doesn't reference where to put the username and password for the authentication if using kerberos authentication. It says to comment them out, save the file, and install from command line. Which I've done, and it errors out stating "Database username must be specified".