SQL Server blocks access to component \ 'ad hoc distributed queries \'

If you want to use OpenRowSet to query a remote database, the SQL Server prompts that the access error to the component \ 'ad hoc distributed queries \ 'is blocked. Search for the error on the Internet and find the solution:

Enable ad hoc distributed queries:
Exec sp_configure 'show advanced options', 1
Reconfigure
Exec sp_configure 'ad hoc distributed queries ', 1
Reconfigure
After use, disable ad hoc distributed queries:
Exec sp_configure 'ad hoc distributed queries ', 0
Reconfigure
Exec sp_configure 'show advanced options', 0
Reconfigure

Select *
From OpenDataSource (
'Sqlodb ',
'Data source = servername; user id = sa; Password = Sa'
). Databasename. DBO. Table

Select * From OpenRowSet ('sqloledb', 'IP address'; 'username'; 'Password', database name. DBO. Table name)