IBM Support

'Could not connect' error in Datasource Builder using 'Windows Authenticated' User in InfoSphere Guardium

Troubleshooting


Problem

'Could not connect' errors in the GUI and 'Login Failed due to NT user' error in SQL Server Management Studio's 'Log Viewer' due to usage of Windows Authenticated User in Datasource Builder.

Symptom

With InfoSphere Guardium, while trying to 'Test Connection' in Datasource Builder for a Window's Authenticated user the error "Could not connect to: 'jdbc:guardium:sqlserver://xxxxxxx' for user 'xxxxx_MS SQL SERVER(xxx)'. DataSource Connect Exception: Could not connect to: 'MS SQL SERVER - xxxxx' for user 'xxxxxx'. SqlState: 28000 Error Code: 18456. ddd0: [guardium][SQLServer JDBC Driver] An error occurred while attempting to log onto the database. SqlState: 08001 Error Code: 0" pops up.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Guardium Database Activity Monitor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21672056

Page Feedback