Click Edit Settings. 7. Edit the repository database settings. HOST NAME The host name or IP address of the database server. PORT The TCP/IP port for connecting to the database server. SIGN IN METHOD [SQL Server] The authentication method: SQL Server Authentication or Windows Authentication. DATABASE NAME The name of the repository database. USERNAME User name for connecting to the database server. The user account must have the following privileges: MySQL / MariaDB - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW on all database objects PostgreSQL - Can login, Can create database and Superuser SQL Server - CREATE, UPDATE, SELECT and DELETE PASSWORD Password for connecting to the database server.
Click Edit Settings. 8. Edit the repository database settings. Host Name The host name or IP address of the database server. Port The TCP/IP port for connecting to the database server. Sign In Method [SQL Server] The authentication method: SQL Server Authentication or Windows Authentication. Database Name The name of the repository database. Schema Name [SQL Server / PostgreSQL] The name of the schema. Domain [SQL Server] The domain name of the database server. Username User name for connecting to the database server. The user account must have the following privileges: MySQL / MariaDB - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW on all database objects PostgreSQL - Can login, Can create database and Superuser SQL Server - CREATE, UPDATE, SELECT and DELETE Password Password for connecting to the database server. Use SSL Authentication Cert Name The name of the SSL certificate. CA Certificate Paste the trusted SSL certificate authorities. Client Key Paste the contents of the SSL key file. Client Certificate Paste the contents of the SSL certificate file. Verify server certificate against CA Enable to check the server's Common Name value in the certificate that the server sends to the client. Specified Cipher Choose a permissible cipher to use for SSL encryption.
Click Edit Settings. 7. Edit the repository database settings. Database Type The type of the database server IP Address The host name or IP address of the database server. Port The TCP/IP port for connecting to the database server. Database Name The name of the repository database. Username User name for connecting to the database server. The user account must have the following privileges: MySQL / MariaDB - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW on all database objects PostgreSQL - Can login, Can create database and Superuser Password Password for connecting to the database server.
