Configuring the Configuration Database

after you have installed , the system configuration wizard starts automatically and displays the configuration application page on this page, you will do the following specify the name of the configuration database and the authentication method that is used by all supported web applications when connecting to the configuration database create or recreate the configuration database if you use windows integrated security for the configuration database, specify the windows domain credentials for the service account configuration application page enter values into the fields parameter description target environment deployment choose one of the following single server deployment if you are setting up the minimum production deployment docid 4c60s2zyg3bmxq48g88sz multiple server deployment if you are setting up the enterprise production deployment docid\ bhapgl 9cpnjelwecs8ll target landscape (only if you selected multiple server deployment) click the down arrow the system displays the target landscapes dialog box on the first server that you configure, check production and click ok on subsequent servers, check any combination of landscapes other than production and enter values in the subsequent fields see below target landscapes dialog box production configuration server (only if you selected multiple server deployment and selected anything other than production in the target landscape field) the host or domain name of the configuration server for the production instance do not enter the information for any other instance; you must enter the information for the production instance port (only if you selected multiple server deployment and selected anything other than production in the target landscape field) the port number of the production server the default is 80, or 443 if you check use ssl use ssl (only if you selected multiple server deployment and selected anything other than production in the target landscape field) check to enable ssl encryption to the server centralconfig api key (production) centralconfig api key of the production environment to retrieve the centralconfig api key, navigate to the configuration console > configure > security controls > api keys > centralconfigapikey (key groups) > centralconfigapikey) click ok to close the target landscapes dialog box under sql high availability , select the multi subnet failover checkbox if the sql servers fall under separate subnets multi subnet failover in sql server is a feature designed to enhance high availability and disaster recovery in environments where failover cluster instances (fcis) or always on availability groups span multiple subnets this configuration ensures that sql server can efficiently handle failovers across geographically dispersed or separate subnets enter values into the fields parameter description configuration database server name the server where the configuration database is located do one of the following accept the default value enter the name of the server of the configuration database browse for a server name by clicking the down arrow and selecting \<browse for more > the system displays any microsoft sql server instances in your network choose a server and click ok note do not choose localhost unless you are setting up a demonstration or proof of concept deployment docid\ g8olkisyshsvioayypcuc configuration database name the name of the configuration database the default name is configdb and you cannot change the name authentication method select one of the following windows authentication uses microsoft windows authentication sql authentication uses microsoft sql authentication if you select this option, enter the user name and password below user name (only if you selected sql authentication) the user name associated with the microsoft sql authentication note if your deployment store filestream attachments, specify a configuration database user account that has a db owner role on microsoft sql server see task 2 setting up neurons for itsm docid\ pygekqx1fjvvfkaem ku1 password (only if you selected sql authentication) the password associated with the user name for the microsoft sql authentication click test connection to test the connection to the configuration database server the system displays connection successful! if the connection is good you must have a working connection to create a database you cannot continue with the configuration if this connection does not work depending if there is already a configuration database, click load configuration database or re create & load configuration db if the configuration database already exists, the system asks if you want to recreate the database click yes the system displays the new database dialog box new database dialog box enter values into the fields parameter description configuration database name the name of the configuration database the default name is configdb and cannot be changed configuration database location the location for the configuration database note if you have customized the existing configuration database, specify a different location; otherwise, the system overwrites your customization when you load the recreated database collation the set of rules that describe how to compare and sort strings, such as the order in which letters are sorted and whether case matters note ism application does not support case sensitive sql collation advanced options logical name the logical name of the configuration database this name is stored as a file name, and is a separate entity from the read only database name that is displayed in microsoft sql server management studio file type the file type, either database records or database logs these values are read only initial size (mb) the initial file size, in mb, when creating the configuration database autogrowth specifies how the database will expand when it reaches its maximum file size we recommend having at least 1 gb or 10% to start with click to update the values path the location of the file click to update the location file name the name of the file click ok the system creates the configuration database and installs it on the configuration database server that you specified several progress dialog boxes appear as various microsoft sql scripts execute to create and load the configuration database after the system loads the configuration database, the configuration application page displays configuration database loaded click next the system refreshes the configuration application page (if you end up on the next page of the system configuration wizard, click previous to return to the configuration application page ) enter values into the fields parameter description configuration server domain name the fully qualified domain name of the configuration server in this format config servername com license server the name of the license server we recommend using a fully qualified domain name port the port number of the license server the default is 80, or 443 if you check use ssl use ssl check if the license server uses ssl ivantism license file production the name of the license file for the production instance click browse , navigate to the license file, and click open license files have a lic suffix note the system displays either one or both of the license fields, depending on your landscape environment at this point, you only need to enter one license, which allows the license manager to start and run you can import additional licenses, if needed, at a later time from within the license manager see using the license manager docid\ hjmsvreybhe0xdorxmsw5 ivantism license file non production the name of the license file for the non production instance click browse , navigate to the license file, and click open license files have a lic suffix note the system displays either one or both of the license fields, depending on your landscape environment at this point, you only need to enter one license, which allows the license manager to start and run you can import additional licenses, if needed, at a later time from within the license manager see using the license manager docid\ hjmsvreybhe0xdorxmsw5 create the administrator account for the configuration database you only need to create this account once if you return to this page in the system configuration wizard later, these fields are not displayed enter values into the fields parameter description login id the system automatically displays the login id of hswadmin you cannot change this password the password associated with the administrator record this password for future reference if you lose the password, you must recreate and load the configuration database confirm password re enter the password associated with the administrator first name the first name of the administrator last name the last name of the administrator email address the email address of the administrator do one of the following if you chose single server deployment, click next the system displays the application page if you chose multiple server deployment, repeat all of the steps in this procedure to create a configuration database for each of your tenants then click next the system displays the application page