Hi,

This type of problem exists when you are using the linked queries that reference the remote server which could not be login on a trusted connection coz, Sql uses the trusted connection to create a link between the servers.

You can use the OpenRowset function in your procedure where you are using the linked  queries.

Thanks.

Amit Gupta (MVP)