SQLServer client authentication can be configured to use either Windows or mixed-mode Authentication.
This page describes configuration changes that are needed if your SQLServer Database Administrator requires client applications to connect with Windows authentication using either Integrated or Domain Authentication.
It is only applicable for the following products
- Enterprise Gateway for Windows
- Enterprise Gateway for WinCPU
Assumptions:
You SQLServer Database Administrator has configured the database server to allow a Windows Local or a Windows Domain account to access the database.
Configure the transport to use Domain Authentication
- Navigate to the Transports panel and select the transport for editing.
- Select the 'Extended Attributes' button to bring up the 'Extended Attributes' panel.
- Select 'Add' to bring up a popup panel to enter
an item as described below.
Name Value Property Type in integratedSecurity Value Type in true Type Select boolean from the picklist - Select the 'Add' button and the extended attribute should be displayed on the Extended Attributes panel.
- Select 'OK' to dismiss the popup
- Select 'Save' to store the definition.
Configure the Transaction Engine service entry with Windows domain credentials
- The Transaction Engine service needs to be configured to use the Local or Domain credentials.
- Navigate to the windows Services menu.
- Select the 'deviceWISE Transaction Engine' service and bring up the service configuration menu.
- Navigate to the 'Log On' tab.
- Select 'This account' and enter the appropriate Local or Domain credentials.
- Select 'Apply' to store the settings.
- Restart the 'deviceWISE Transaction Engine' service in order for the settings to take effect.
Firmware update consideration
When you apply a firmware update the credentials of the windows service entry will get reset to the 'Local System' account. You will need to re-configure the Local or Domain credentials in the service configuration panel.