IBM Support

How to create connection to Microsoft SQL Server with Windows Authentication

Question & Answer


Question

Microsoft SQL Server connection allows access to SQL Server with SQL Server Authentication mode.
image 11684
However, the connection failed when we use Windows Authentication to access database on Microsoft SQL Server with "Unable to authenticate" error messages.
image 11685

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSHE3N","label":"IBM Watson Studio Premium for IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m0z000000GpDZAA0","label":"Services and Integrations"}],"ARM Case Number":"TS007009295","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

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:
07 October 2021

UID

ibm16497203