Posted by: bart30508 | in SQL Server | 11 months ago |

SQL Server--Msg 7399, Level 16, State 1 Linked Server. Access Denied/OraOLEDB.Oracle.InProcess Mean

To troubleshoot, first I open up the provider. In this case, it was the OraOLEDB.Oracle provider.

I forgot to enable Allow inprocess.

Here it is correctly enabled.

What does Allow inprocess do? From the documentation:

allows the provider to be instantiated as an in-process server.

When this option is not set, the default behavior is to instantiate the provider outside the SQL Server process. Instantiating the provider outside the SQL Server process protects the SQL Server process from errors in the provider.

When the provider is instantiated outside the SQL Server process, updates or inserts referencing long columns (text, ntext, or image) are not allowed.

To read more about the settings available for linked servers, the documentation is a good read: https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver15