ODBC destination stops logging new messages to a remote SQL Server
Possible cause and solution:
- The remoteSQL ServerusesWindowsauthentication, and the user name configured for the ODBC Log is not fully qualified. If the domain to which the user name belongs cannot be determined, the connection to the database fails.To solve this problem:
- InFactoryTalk Administration Console, selectTools > Diagnostics Setup.
- ExpandDestination Setup, and then selectODBC Database.
- If it is not already selected, selectLogin required.
- InUser name, type the login user ID for the database.When usingWindowsauthentication (rather thanSQL Serverauthentication), enter the fully-qualified user name in the formatDOMAIN\UserNameoruser@domain.com(for UPN-style entries).
- InPassword, type the password for the user account.
- InConfirm password, type the password for the user account again.
- SelectOK.
Provide Feedback