Solved

SSRS 2005: wont run over web portal

Posted on 2012-03-15
6
285 Views
Last Modified: 2013-01-24
hi all

i have a an ssrs report that points to a sql 2005 datasource,

locally on server i have visual studio installed the report runs fine

when i try to run it over the \\sqlserver\reports address is fails with the error:

An error has occurred during report processing.
Cannot create a connection to data source 'AchItil01'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors



any ideas?

mal
0
Comment
Question by:malraff
  • 2
  • 2
6 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 37726545
How do you "run it over the \\sqlserver\reports address " and with what NT credentials? Are you using exactly the same NT login as when you  run it "locally on server i have visual studio installed the report runs fine"
0
 

Author Comment

by:malraff
ID: 37729025
i am running with the same logon credentials in each scenario

i have the report setup to use windows integrated security

it works locally eg
\\localhost\reports when on the actual server works fine
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 37729700
OK - if you can run it from \\localhost\reports what how do you run it from a client logged on with exactly the same NT login as it is working from server?
I would run it as IP not servername like: \\123.123.123\reports
Also can you edit the report and check credentials from that client under Report Manager URL? like \\123.123.123\report manager or whatever name you gave to that SSRS rpt manager web site.

Here's and article to help you troubleshoot the error:
http://msdn.microsoft.com/en-us/library/ms156468.aspx
0
 

Accepted Solution

by:
malraff earned 0 total points
ID: 37741583
i want back to basics and setup a new shared connection source which uses a limited access sql account and all is working fine now!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now