Why does openrowset prompt that sqlserver does not exist?

flytothesea

select a. * from openrowset ('SQLOLEDB'
 , '192.168.0.121'; 'sa'; '12345'
 , master.dbo.sysobjects) as a

Message 17, Level 16, State 1, Line 1
[DBNETLIB] [ConnectionOpen (Connect ()).] SQL Server does not exist or access is denied.

opensource also makes this error?
What is the problem?

cv4bf5d65fd

Is the database server service you want to open started?

fanfan1980

--Example

USE pubs
GO
SELECT a. *
FROM OPENROWSET ('SQLOLEDB', 'seattle1'; 'sa'; 'MyPass',
   'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a
GO

fanfan1980

--try

select a. * from openrowset ('SQLOLEDB'
 , '192.168.0.121'; 'sa'; '12345'
 , 'select * from master.dbo.sysobjects') as a

我是杀人狂

select a. * from openrowset ('SQLOLEDB'
 , '192.168.0.121'; 'sa'; '12345'
 , 'select * from master.dbo.sysobjects') as a

小老鹰

select a. * from openrowset ('SQLOLEDB'
 , '192.168.0.121'; 'sa'; '12345'
 , master.dbo.sysobjects) as a

->

select a. * from openrowset ('SQLOLEDB'
 , '192.168.0.121'; 'sa'; '12345'
 , 'select * from master.dbo.sysobjects') as a

flytothesea

The reason is clear, there is a problem with the database server settings. Thank you all!