Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linked server, error 4064

Status
Not open for further replies.
May 17, 2006
54
US
I created a query that links 2 servers (used sp_addlinkedserver). I used this query for a Crystal report. Works fine if I run the report. I assume because I have admin rights. My users get a 4064 (failed to retrieve data) error code when running the report however. Any ideas on how to get rid of this error?

Thanks ...
 
Thanks for the response Frederico.

I'm not sure that's the issue though. If I remove the part of the query that accesses the linked server (it is a union query with the second part hitting the linked server) the users can run the report successfully. They just don't get any data from the second server.
 
I figured out to do this for one user. If I run this command I can get it to work for jsmith:

EXEC sp_addlinkedsrvlogin 'pcisv002', 'false', 'domain\jsmith, 'report', 'report'

What would be the same command but that would work for all users? I don't want to have to run this for every current and future user.

Thanks ....
 
This seems to have taken care of it:

EXEC sp_addlinkedsrvlogin 'pcisv002', 'false', @rmtuser = 'report', @rmtpassword ='report'

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top