Hello all,
I have a small issue at my end.

I have 2 databases A and B.
A is in machine m1 and b is in machine m2.
I want to select some data from B database thru A database.
I have added Linked server and Linked server login too

Later when i run a Query as below from 'A' Database

select * from openquery(select . . . . . from <Table in b database> );

It gives me an error saying M2 is not configured for Data accesss..
Please help me in ths regard / direct me to a tech white paper on this issue..

thanks and regards