[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

reporting services needs to pull data via linked-server

Posted on 2008-10-09
2
Medium Priority
?
678 Views
Last Modified: 2008-10-16
I have SSRS 2005 on Server A. I have data on Server B. A linked server exists on both servers to pull data. The report works just fine in Visual Studio.

After I've deployed the report to SSRS on Server A, I am getting an error that states "An error has occurred during report processing. Cannot create a connection to data source 'VIP_Data' " 

(VIP_Data is a data source that points to the data on Server B.)

I assume this issue has to do with setting security to  Windows Authentication and that my credentials are not being passed to Server B.

What is the work-around?
0
Comment
Question by:GRIPA1
  • 2
2 Comments
 
LVL 31

Expert Comment

by:James Murrell
ID: 22686741
0
 
LVL 31

Accepted Solution

by:
James Murrell earned 1500 total points
ID: 22686793
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question