Enable Windows Authentication SQL Server
Perform the following steps to enable Windows Authentication for SQL Server:
- Open the Windows Service management console and stop the following services:
- FactoryTalkAnalyticsDataView
- FactoryTalkAnalyticsDataImporter
- Download the JDBC driver from the following website: https://go.microsoft.com/fwlink/?linkid=2168495.
- 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.
- Copy the JDBC driver to thejdk>binfolder path:C:\RockwellSoftware\FactoryTalkAnalyticsDataView\jdk\bin
- Start the DataImporter service with the User which has been added in SQL server:
- FactoryTalkAnalyticsDataImporter
- Open the Windows Service management console and start the DataView service:
- FactoryTalkAnalyticsDataView
Provide Feedback