Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 577
  • Last Modified:

SRS 2008 Cannot connect ot datasource

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
raybar111
Asked:
raybar111
1 Solution
 
big_one01Commented:
Store the credentials securely within the datasource on the report server itself.
Enable Kerberos on the network .
0
 
raybar111Author Commented:
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
 
twolCommented:
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
 
mlmccCommented:
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now