Solved

SSRS 2005: wont run over web portal

Posted on 2012-03-15
6
302 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

772 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