I have a reporting services 2005 report that works fine in the designer. BUt when I deploy it, I get an error as follows: An error has occurred during report processing. Query execution failed for data set 'ds_E_And_M'. Login failed for user 'nglink'. The report reads data from a SQL 2005 server and an SQL 2000 server (which is setup as a linked server and links using a sysadmin account) using a stored procedure. The stored procedure works fine as well. There is no user called nglink anywhere on either server. I have dropped and recreated the link server as well. And I have also deleted and deployed the report again. I am just confused about where this user "nglink" is coming from. Seems like its caching some old user information, but I cannot find it. The datasource itself connects using a share datasource. There are other reports based on the same datasource that work just fine. And as I said this report works fine in the designer. Any suggestions?

Is it possible your application connects with in that user and trying to execute report? BTW , is it report viewer? Turn on sql server profiler to capture audit failed login eventBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

No Its not a report viewer. I am just looking at this report on the SSRS website.

Seems like its caching some old user information, but I cannot find it. The datasource itself connects using a share datasource. Hi DeveloperIQ, To find the cache file, you could follow below steps: Right-click the RDL report and then select properties, you will see FullPath, open the location, there are some rdl and cache file, such as: ReportName.rdl.data, delete the cache file and have a try, if the issue still exist, please give a feedback. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

From the error it seems that your datasource is using nglink user and this user does not exists on the database server. Change the credentials of dataset "ds_E_And_M" to use a specific user name from its property windows. Hope this answers your question

I have tried both things. Clear the cache and also used a specific user for ds_E_And_M. Still the same result and same error message

This was an error on the linked server end. I dropped all logins and recreated them and its all working now.

I’m glad to hear that you resolve this issue. Thank you for sharing your solutions and experience here. Please remember to mark the replies as answers if they help and unmark them if they provide no help.