Solved

SSRS 2005: wont run over web portal

Posted on 2012-03-15
6
318 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 40

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 40

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 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