During the installation, certain prerequisites must be included in the DB connection configuration to ensure that connectivity is established. This is supported by the ConnectAll installer. Follow the below routine to get the DB configured.
- If you are using MS SQL Server, configure as instructed below in the ConnectALL DB Configuration screen:
- Database URL with Port: [serverName[\instanceName][:portNumber]][;property=value[;property=value]] (Exclude the database name, user, and password as they will be deciphered from the below values)
- Database Name: <<PREFERRED DB NAME>>
- DB User: <<PREFERRED DB USER>>
- Password: <<USER SPECIFIC PASSWORD>>
Examples: - localhost;integratedSecurity=true;
- 127.0.0.1:1433;useCursors=false;integratedSecurity=true;
For Windows authentication, add only the domain name in the DB URL and add the windows credentials to successfully connect with the DB. Below is the screen snapshot for Windows Authentication.
- If you are using MySQL or Postgres, configure as instructed below in the ConnectALL DB Configuration screen,
- Database URL with Port: [host][,failoverhost...][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]... (Exclude the user and password as it will be deciphered from the below values)
- Database Name: <<PREFERRED DB NAME>>
- DB User: <<PREFERRED DB USER>>
- Password: <<USER SPECIFIC PASSWORD>>
Examples:
- localhost:3306/muledb?
useUnicode=true - localhost:3306/muledb?ssl=true&autosave=conservative
Please ensure the properties provided in the host string are specific to the type of DB chosen (MySQL or Postgres). Otherwise the given values may not be honored while establishing a connection and could stall the installation.
- For Oracle DB, the database URL with the port field can be populated as below with the properties respectively:
(DESCRIPTION=(ADDRESS=(PROTOCOL=<<PROTOCOL>>)(HOST=<<HOSTNAME>>)(PORT=<<PORT_NO>>))(CONNECT_DATA=(SERVICE_NAME=<<SERVICENAME/SID>>)))