During the course of installation, there are certain prerequisites to be included in the DB connection configuration to ensure the connectivity is established. This is supported by the ConnectAll installer. Follow the below routine to get the DB configured.
- For MS SQL Server, in the ConnectALL DB Configuration Screen, configure as instructed below:
- Database URL with Port: [serverName[\instanceName][:portNumber]][;property=value[;property=value]] (Exclude the databasename, 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;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
2. For MySQL and Postgres, in the ConnectALL DB Configuration Screen, configure as instructed below:
- 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.
3. For Oracle DB, the database URL with port field can be populated as in below with the properties respectively:
(DESCRIPTION=(ADDRESS=(PROTOCOL=<<PROTOCOL>>)(HOST=<<HOSTNAME>>)(PORT=<<PORT_NO>>))(CONNECT_DATA=(SERVICE_NAME=<<SERVICENAME/SID>>)))