Access is denied (login-mapping)

[simonsez]

I am using crystal 8.5
SQL Server 2000

I have created a main report off of my SQL Server database which is accessing the data fine, the problem comes into my subreport.

I have multiple linked servers which I have created a view in my database off of...my subreport is using this view as it's data source. The view is a UNION ALL query using one table from two linked servers.

The query runs in SQL Server, but when trying to look at any data in crystal, it errors out giving me:

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] Access to the remote server is denied because no login-mapping exists.

I can connect to the view and see the fields, but when trying to run the subreport to see any data it errors out.

Any Help? Do you need anymore information?
Thanks
simonsez