Enable Windows Authentication SQL Server

Perform the following steps to enable Windows Authentication for SQL Server:
  1. Open the Windows Service management console and stop the following services:
    • FactoryTalkAnalyticsDataView
    • FactoryTalkAnalyticsDataImporter
  2. Download the JDBC driver from the following website: https://go.microsoft.com/fwlink/?linkid=2168495
  3. In the SQLServer, create the user with <Network Domain>/<username> and change TCP/IP to enable with IP address in the SQL server network configuration.
  4. Copy the JDBC driver to the
    jdk > bin
    folder.
    Path:
    C:\RockwellSoftware\FactoryTalkAnalyticsDataView\jdk\bin
    JDBC driver - bin Folder
  5. Start the DataImporter service with the User which has been added in SQL server:
    • FactoryTalkAnalyticsDataImporter
  6. Open the Windows Service management console and start the DataView service:
    • FactoryTalkAnalyticsDataView
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.