2022.2

Table Of Contents

l

Basic Connection Settingsselections:

l

Database vendor:Selectthedatabasetypefromthedropdownlist.

Note: Movingfromonevendordatabasetoanotherwillresetallscreenselectionsto

defaults,regardlessofwhatmayhavebeenpreviouslyselected.

l

Database URL:Thisisaread-onlysummationofthecurrentdatabaseconnectionset-

tings.

Tip: IftheTest Connectionbuttonshowsthatthedatabasecannotbesuccessfully

connectedtousingtheselectedsettings,thenthecontentsofthisfieldcouldbeused

totrytoconnecttothedatabaseoutsideofPrintShopMailConnect.Thisshouldhelp

indeterminingandrefiningtheacceptableconnectionoptions.

l

Hostname:EntertheIPAddressoraliasoftheserverwheredatabaseresides.

l

Database Instance Name:EnteranexistingMicrosoftSQLServer'sinstancename.

ThisoptiononlyappliestoexistingMicrosoftSQLServerinstances,andnotforMariaDBor

MySQL.

l

Port:EnterPortnumber.Thedefaultsarethosewhichthevendorsusebydefault.

l

Schema:Theindividualdatabaseschema,withinthevendordatabase.

Note: Ifapreviouslynon-existentschemawerechosenhere,thenanewschemaof

thatnamewillbecreatedwithinthedatabasewhentheback-enddatabaseswapis

applied.Thetableswithinthatschema,though,willnotbecreateduntilConnectis

restarted.

l

Username:Enterthedatabaseloginusername.

Tip: Itisconsideredbestpracticeforthisusertohaverootprivileges.

l

Password:Enterthepasswordassociatedwithselectedusername.

l

Advanced Connection Settingsselections:

l

Maximum concurrent threads:Thisoptionsetsthemaximumdatabasethreads.

ThemaximumsettingisdeterminedbythespecificcapabilitiesofthemachineConnectis

installedupon(CPUspeedandtheamountofcoresbeingthemajordeterminants).

Tip: Leavingthisvaluesettothedefaultmaximumshouldbethebestoptioninmost

circumstances.

Werecommendedthisentrybeleftatthedefaultvalue.

Page 59