Solved

SRS 2008 Cannot connect ot datasource

Posted on 2010-11-10
5
570 Views
Last Modified: 2012-05-10
I have installed and configured SSRS on a 2008 R2 server and SQL 2008. I deployed a bunch of Great Plains reports and can get to them no problem logged in as Domain Admin. I set security for the users in SRS. WHen logged in as a Domain user I can get to the reports but when they try to run I get this error.
"An error has occurred during report processing.
Cannot create a connection to data source 'xxxxx'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors "\\

Any help would be appreciated.
0
Comment
Question by:raybar111
5 Comments
 
LVL 3

Expert Comment

by:big_one01
ID: 34105767
Store the credentials securely within the datasource on the report server itself.
Enable Kerberos on the network .
0
 

Author Comment

by:raybar111
ID: 34106535
I tried storing credentials securely and that gave a different error. I have to admit that I know very little about Kerberos. This is a small Business Server 2008. Dont know if that makes any difference. Thanks for your help
0
 
LVL 7

Accepted Solution

by:
twol earned 500 total points
ID: 34170129
1) On the SQL Server that is acting as the datasource,  add domain level login.

2) On that same server, in the database, add a user, and allow the user read access to tables and views.


0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34770148
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Question 5 36
sql Total query 2 25
SQL Help 27 40
Better way to make a query with date filter. 5 22
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

813 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

12 Experts available now in Live!

Get 1:1 Help Now