Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSRS 2005: wont run over web portal

Posted on 2012-03-15
6
Medium Priority
?
338 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
4 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 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Screencast - Getting to Know the Pipeline

810 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