I am logged into an Azure SQL Database, using "Active Directory - Integrated" authentication wherein I supply my company domain credentials only; no password.
I tried executing OPENROWSET on a .json file stored on my client (laptop):
Select BulkColumn
from OPENROWSET
(BULK 'C:\Users\username\Downloads\docs_by_day_IncludeDocs.json',
SINGLE_CLOB) as my_test
which returned:
Msg 4861, Level 16, State 1, Line 12
Cannot bulk load because the file "C:\Users\username\Downloads
\docs_by_day_IncludeDocs.json" could not be opened.
Operating system error code (null).
Does this error have something to do with Azure SQL Database trying to connect to my local client? Unlike some other posters, the error message does not explicitly identify an Access problem.
I appreciate any assistance!