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

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

參考來源:

https://jimsalasek.com/2021/01/05/msg-7399-level-16-state-1-linked-server-access-denied/#more-3659

tags: SQL Server
Currently unrated
 or 

Subscribe

* indicates required

Recent Posts

Archive

2022
2021

Categories

Apache 1

Data Science 2

Dbfit 1

Design Pattern 1

Devops 3

DigitalOcean 1

Django 1

English 3

Excel 5

Flask 3

Git 1

HackMD 1

Heroku 1

Html/Css 1

Linux 4

Machine Learning 2

Manufacture 1

Mezzanine 18

Oracle 1

Postgresql 7

PowerBI 4

Powershell 3

Python 21

SEO 2

SQL Server 51

SQLite 1

Windows 1

database 8

work-experience 1

其他 1

自我成長 1

資料工程 1

Tags

SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)

Authors

bart30508 (145)

Feeds

RSS / Atom

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

© COPYRIGHT 2011-2022. Max的文藝復興. ALL RIGHT RESERVED.