Solved

Reporting Services Integration Sharepoint

Posted on 2014-01-13
7
414 Views
Last Modified: 2014-01-14
Hi All Hoping somebody can help

We have SharePoint 2010 Installed on 1 server that also has SQL R2 Installed everything regarding this server is fine.

We needed to install SharePoint Foundation 2010 on a separate server for some testing Purposes and tried to install Reporting Services Integration within Central Administration.

Basically in there I want to point it to our Working setup so that I can pull reports of it, however within Database Access I get the following

There was an error when granting Access for domain\administrator to this share point farm. Some or all identity references could not be translated.

Just to add I have a sharepoint server as mentioned above working fine with SSRS working as well, Basically I have added another server with foundation on it and I need to view reports of it within foundation

John
0
Comment
Question by:pepps11976
  • 4
  • 3
7 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39777127
I assume SQL 2008 R2?  The server running SSRS must have SharePoint installed and be joined to the farm.  In that case you couldn't have an SSRS instance serving multiple farms.
0
 

Author Comment

by:pepps11976
ID: 39778650
So I would need to install another instance od SQL on the Foundation Server?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39779191
Yep.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:pepps11976
ID: 39779279
Ok So just to clarify then

If I were to start From Scratch Using Just SharePoint Foundation And SQL Server 2008 R2 on the same box Using SSRS could I add say a bar chart Using SSRS to a SharePoint page and add some kind of Auto Refresh

Do this two products allow me to do this, I am already doing this using SharePoint but I need to know if Foundation has a Limitation on this

Thanks for your help

John
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39779285
How are you doing it in SharePoint?
0
 

Author Comment

by:pepps11976
ID: 39779295
I already have a SharePoint Farm Setup with SQL installed on the Same Box and I have no issues using SSRS web parts there.

You said above that SSRS cannot serve Two Farms which makes Sense,

But I was just wondering If SharePoint Foundation can Show SSRS Reports in Real Time

Hence I was trying it Out By Pointing my Foundation Installation to my Existing SQL Server
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 39779309
Yes, SharePoint Server doesn't offer an advantage over Foundation from strictly an SSRS perspective.  If all you are using on your SharePoint Server is an SP-Integrated SSRS instance and the SSRS web parts, you should be able to do the same in Foundation.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Title # Comments Views Activity
SQL Pivot with row total 5 26
SQL USE DATABASE VARIABLE 5 27
HTML <font style="color:red"> 9 29
Is sending authentication through SOAP secure? 3 14
I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

809 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