AnsweredAssumed Answered

use windows login linked server and no explicit login

Question asked by Dubus on Feb 18, 2019
Latest reply on Feb 19, 2019 by LalBabuShaik

Hi,

 

We would like to create a linked server in MS SQL Server using a specific Windows account to a pi server having No Explicit Login.

Does it possible ?

 

We tried a Local Login (created in SSMS but it's a Windows account) and we put Connection Not be made. We have a connection refused in PI-SMT Message logs because this is an Explicit Login.

 

Any work around ?

Our goal : use a Read Only user to do queries in piarchive.

 

Thanks

Outcomes