AnsweredAssumed Answered

Facing issue while connecting to PI server via SQL DAS

Question asked by shallugoyal on Jul 8, 2020
Latest reply on Jul 29, 2020 by jyi

#we have client machine which has SQL DAS installed in it to connect with PI server

Mapping is created in PI serevr for aithenatictaion

After enabling TLS1.2,connection is not able to set via SQL DAS on PI server, earlier we had TLS 1.0 and 1.1 enabled.

Getting below error in PI Message logs (After Enabling TLS 1.2)

Unsuccessful login ID: 12151. Address: 10.233.x.xxx. Name: PISqlDas.exe(5256):remote. Credentials used: NT AUTHORITY\ANONYMOUS LOGON. Method: Windows Login (SSPI,NTLM). Error: [-10433] No identity mapping for this request

 

Getting below message in PI message logs (before enabling TLS 1.2)

Successful login ID: 8092. Address: 10.233.x.xxx. Name: PISqlDas.exe(6852):remote. Identity List: PIRead_QGCCUR_L3Confidential. Environment Username :BRIPLD-S-xxxx-S. Method: Windows Login (SSPI,Kerberos)

 

 

Outcomes