SQL remote Query

Method 1:
Statement:
Select *
From OpenDataSource ('sqlodb', 'password = password; persist Security info = true; user id = user name; Data Source = database Server'). database. DBO. Table Name

An error is prompted after running:
SQL Server blocks access to the statement 'openrowset/OpenDataSource 'of the 'ad hoc distributed queries' component because this component has been disabled as part of the server's security configuration. The system administrator can enable 'ad hoc distributed queries 'by using sp_configure '. For more information about enabling 'ad hoc distributed querys', see "peripheral application configurator" in SQL Server books online ".

Solution:

-- Enable ad hoc distributed queries:
Exec sp_configure 'show advanced options', 1
Reconfigure
Exec sp_configure 'ad hoc distributed queries ', 1
Reconfigure

Select *
From OpenDataSource ('sqlodb', 'password = password; persist Security info = true; user id = user name; Data Source = database Server'). database. DBO. Table Name

-- Disable ad hoc distributed queries after use:
Exec sp_configure 'ad hoc distributed queries ', 0
Reconfigure
Exec sp_configure 'show advanced options', 0
Reconfigure

Method 2:

Exec sp_droplinkedsrvlogin database server, null
Exec sp_dropserver Database Server

Exec sp_addmediaserver
@ Server = 'database Server ',
@ Srvproduct = '',
@ Provider = 'sqloledb ',
@ Datasrc = 'database'

Exec sp_add1_srvlogin
'Database Server ',
'False ',
Null,
'Username ',
'Password'
Query: Select * from database server. database. DBO. Table Name

Error after running:

Named Pipe provisionProgram: Unable to open connection with SQL Server [53].
Solution:
No method found. I have tried several methods on the Internet.