...
A standard PING command will be fired to the SQL Name/IP server to validate it exists.
A standard SQL Connection will then be made to the SQL Name/IP server to validate the SQL Username and SQL Password are correct.
A standard PING command will be fired to the SYSPRO Name/IP server to validate it exists.
A standard PING command will be fired to the WMS Name/IP server to validate it exists.
| Child pages (Children Display) |
|---|
Save Steps
Once the validation is successful, a registry entry will be created as follows:
HKEY_LOCAL_MACHING\SOFTWARE\WOW632Node\DATASCOPEWMS\
The following string entries, shown in BLUE, will be made. These are all the values entered on the above-mentioned form.
...
The following screen will appear: Core Service Account. These are the details for the account used to run the WebAPI and Core Services DATASCOPE WMS Services on the new Server.
...
The next screen in this option looks as follows, and the integration here is mentioned below in some detail. This refers to the linked databases.
...
When this screen is loaded, a query is made to the following database table to obtain a list of
the SYSPRO Companies that are set up.
Database Name | Sysprodb |
Table Name | SysproAdmin |
If the standard Sysprodb does not exist, the operator will be asked to specify it. When this happens, a query is made as follows.
Database Name | master |
Table Name | sysdatabases |
When selecting Next, the next SYSPRO Company Databases can be configured.
...
The option exists to create a third SYSPRO Company as well.
Once the list of SYSPRO Companies has been obtained, the operator can loop through each company and configure the SYSPRO and WMS Databases, respectively. Each drop-down will be loaded by querying the below:
Database Name | master |
Table Name | sysdatabases |
Once the operator moves to the next company, the below entries will be added to the registry as follows:
HKEY_LOCAL_MACHING\SOFTWARE\WOW632Node\DATASCOPEWMS\
The following entries in BLUE will be added/updated.
| Info |
|---|
NOTE: Each company will have the entries prefixed with the SYSPRO Company Letter in this case TMS_ |
...