To execute OPENROWSET commands successfully we need to enable Ad Hoc Distributed queries since by default it will be turned off

To configure this follow the following:

sp_configure ‘show advance option’,...