Forum Discussion
OraOLEDB Linked Servers work with one SA login but not another
I am running SQL Server 2019 with a few dozen MSSQL, Teradata and Oracle linked servers on several Windows Server 2016 machines (different environments - dev, test, etc.). All linked servers are set ...
The solution was to turn on the AllowInProcess flag for the OraOLEDB.Oracle provider.
EXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1
