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.