access tables from different server

[coolminded]

dear all,
i have two servers and my software is in one of those servers. both the servers have databases : db1 and db2.

i tried the following query :

select * from server2.db2.dbo.tblname

from server1. it shows the error

Msg 7202, Level 11, State 2, Line 1

Could not find server 'server2' in sysservers. Execute sp_addlinkedser ver to add the server to sysservers.

what shall i do.i need both servers.

TIA

[ck9663]

Have you link server2 yet? Here, read this

Happy Coding!!!

~~ CK