Error 1385 With SystemLink FileIngestion Service Using Microsoft SQL Server

Issue Details

• After configuring a Microsoft SQL Server connection in SystemLink, the FileIngestion service errors.
• In the NI SystemLink TDM Configuration application, I am using an SQL Server connection for the Resource Manager Service. In the SystemLink log files, I see error 1385.
• I want to use a Microsoft SQL Server to store SystemLink TDM information. In the Skyline logs of the TDM Diagnostics, I see the below error.

Solution

1. Open the NI SystemLink TDM Configuration application on the server PC.
2. Select the SystemLink TDM User Account tab.
3. Ensure that you are using a Windows user account that meets the below criteria. If a Windows user account is already in place, skip to step 5.
   • The password does not expire.
   • The account has access to network shares used by SystemLink.
   • The account belongs to a group of local administrators.
4. Click Apply. If prompted to allow the account to log on for services, click Yes.
5. Verify that the TDM User Account is used for the SystemLink TDM Account Service:
   1. Open the Windows Services application.
   2. Scroll to find the SystemLink TDM Account Service.
   3. Ensure that the Log On As column shows the TDM User Account.
   4. If it does not, right-click SystemLink TDM Account Service and select Properties.
   5. Select the Log On tab.
   6. Select This account and enter the same username and password set for the TDM User Account.
   7. Click Apply and then start the service.
6. Ensure that the following services are set to Automatic and Running:
   • NI PSP Service Locator.
   • NI SystemLink Forwarding Service.
   • NI SystemLink Message Bus.
   • NI SystemLink Service Manager.
   • NI SystemLink TDM Account Service.
   • NI SystemLink TDM Database Service.