Query Another SQL Server, without Linked Server ?

Hi Experts,

I would like to query a table on another Sql Server within our system.

Similar to this post here...
http://www.experts-exchange.com/Database/MySQL/Q_22458554.html

I am using the correct Syntax I believe, but I can't seem to get across to it?

I am getting this error?
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'DbServerNane' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

Do I have to add a linked server? Or just connect using OpenRowSet or some other method?Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:

SELECT *
FROM DBServerName.DBCatalogName.dbo.calendar
 
 
SELECT *
FROM 
OPENROWSET('SQLOLEDB', 'Server=DBServerName;user_id=Username;password=Pwd;',
     'query=SELECT * FROM DBCatalogName.dbo.calendar')