SQL Server 2005 Linked Servers Via Crystal Reports

[Skittle]

I have set up a linked server to another SQL Server 2005 instance on our network using windows authentication.

I have created a view on my SQL server that selects data from a table on the server. It works fine in SQL server management studio.

I have then tried to access the view in my server database
via a crystal reports connection. I can login. I can see the view. I can select fields. But when I run the report query, I get an error:-

Failed to open rowset.
Details:28000:[Microsoft][ODBC SQL Server Driver][SQL Server] login failed for user 'NT Authority\Anonymous Logon'.

If I try to access a view in the same database that does not reference the linked server, there is no problem.

Anybody any clue what is wrong?

Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.

 

[Skittle]

It is the 'double hop' windows authentication problem.
I executed the following to make it work.

EXEC sp_addlinkedsrvlogin 'SQLSERVER2', 'true'

Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.