> For the complete documentation index, see [llms.txt](https://kythuat.dtechvn.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kythuat.dtechvn.com/sql-server/sql-server-blocked-access-openrowset-opendatasource.md).

# SQL Server blocked access (OpenRowset/OpenDatasource)

## CHẠY CÂU LỆNH QUERY SAU:

```sql
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE WITH OVERRIDE
GO
```

Thường áp dụng cho việc chạy các câu lệnh có sử dụng OPENDATASOURCE / OPENROWSET để truy vấn.