Hi, I am unable to run the following query from server:cd_pdserv02.DBTBB_BACK and getting the linked server error. How I can grant the access of linked server to run the query. OR is there anyway to run the query successfully. Thanks for your help
Select * from [cd_pdserv01].DBTRB_BACK.dbo.[rule]
--Could not find server 'cd_pdserv01' in sys.servers.
Can I run the above query with OPENDATASOURCE? How I can run with OPENDATASOURCE?