Hi Harsha,

How you are transferring data from one server to another. There are many ways like backup and restore, dts and bcp, database mirroring, logshipping etc..

version of both sql server and sp version.?

did u try to connect from server a to server b using the query analyzer.

Did u check whether the login you are using has sufficient permissions on the server b.

Did u try the concept of linked server.

Thanks

Chandra Mohan N