AnsweredAssumed Answered

PI AF link table connection issue

Question asked by philco on May 14, 2018
Latest reply on Jan 30, 2019 by SwatiAggarwal

This is a question about the security of the PI AF link tables. The source of an existing linked table in AF needs to be moved from SQL server A to SQL server B. The connection string is set to "Integrated Security=SSPI". The linked table on SQL server A is working well but when trying to connect to the new one on SQL server B there's a connection error: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON". Worse, it's working well on the PI AF server but not on other computers. Which security should I look at? PI AF or MSSQL server or ? Thanks for your help.

Outcomes