.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Share Point integrated SSRS reports rendering when access from external site

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

View Complete Post

More Related Resource Links

Schedule reports with integrated authentication SSRS 2008

Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

Need to find File Share Excel Rendering time--SSRS 2008

we are using SSRS 2008 file share subscription to generate EXCEL reports,Requirement here is need to find the file rendering/completion time in order to send the excel file as attachement using xp_senddbmail. Your help is highly appreciated-- Sathish

How to find newly added item in the share point site?

How to find the recently added item in the share point page If the any user added the items in the custom list, library, list,Announcement, Picture library,etc......... i need to show all item that added last 2 days. Is that any object model available to find all item in the share point site???Instead of searching every list.

Need the old "Browser" access in the new SharePoint Integrated with SSRS

0 down vote favorite Does anyone know of a way to add or remove items from the "Actions" menu within a report on SharePoint 2010 Integrated with SSRS 2008 R2? I would like to remove "Open with Report Builder" and add "Subscribe" to the Actions menu. I'm working with my SharePoint Server Admin who is at a loss also. I have found how to remove Report Builder from the server but the Admin doesn't want to do that since I am not his only customer. The "Subscribe" option seems to be driven from permissions but I'm not able to get it to show up for my read-only viewers. It shows up for me but I'm not going to give them admin rights. Basically, what I want is the "Browser" role from Report Manager: "May view folders, reports and subscribe to reports." They couldn't open in Report Builder. It seems so basic. I just want people to view reports and if they'd like, subscribe to them. Thank you

SSRS 2008 Against OLAP Cube reports rendering slow in IE 6 and IE8

We have SSAS cube built on SQL Server 2008 that has multiple parameters that have a default vault on running of all. The first time we run the report it renders the report in less than 30 seconds, but when we change one value on the data cube pull the reports can take up to 5 mins to run. If I do the same report in Firefox 3.6 it renders the report in 30 seconds. I have change changing the cache size in the IE explorer and ave the latest .net frame work on the computer. What would be causing this issue? The company upgrade from SSRS, SSIS, SSAS, SQL 2005 to 2008. Please advice, this is very annoying for our business end users.   Thanks for your help in advance.

Public Access to SSRS Reports


I'm designing some reports to summarize recently compiled research findings.  These reports are going to be posted on an ASP.NET page (via the report control) on the web site.  I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.

I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup.  I need alternative solutions to the problem of making a report viewable by everyone who visits a site.  I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.

External Sharepoint 2007 Personal Site Access



I would like to have our current Sharepoint 2007 Personal Sites accessible externally to the end users via https and forms based authentication.

Can anyone advise the steps/best way to achieve this?






How to make Quicklaunch of share Point site movable?


How to make Quicklaunch of share Point site movable?(so is its not needed , it should be moved to leftmost direction)

                                                                                     Thanks and Regards,

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

how to Selec site Tempalte Picker using Code in Share point 2007


Hi Guys,

My Requirement is: I have an page it's coming from _Layouts,that page contains one Template Picker Control(share point control).so it showing all site templates like Team site,Wiki site etc.

But My Issue is i have site template id like "STS#1" Now i need to show  this site template in  Template Picker Control using c# or Object model code.how to do that right know it selected  Default site template.

Thanks In Advance.

Murali krishna.T


Share point database and site collection size, and restrictions and workflow


Sharepoint site collections


More Detail



We had a 3rd party into to develop the share-point service, This is really a very difficult situation not the solution but the documents that are stored and the way it was retrieved.


The real thing is that we receive an item it is booked into SAP and then we send an automated xml to set up a local site this site will then have details from the SAP system fed by ABAP. After the site is created, and then we add documents files and .jpg. These documents must show a detailed audit trail so that if challenged in a court of law can show who had access and who updated documents. 


SO the problem is 


1 Site Collection that is 170gig and the design means that we have 1600 sites and these contain images that are stored in the single site collection. How do we remove the full documents and images and replace with links rather than the doc, img. 


2. We have around 8 business units the problem is that they can share information acros

why all buttons under documents disabled when we add custom webpart to a share point site?


I am adding buttons under shared documents.i am using vs2010 for that.now i am add custom webpart to the pite all buttons under the ribbon are disabled.

why all buttons under  documents  disabled when we add custom webpart to a share point site?

how to get current user permission,all permissions in share point site using object model



how we will get current user permission using object model to a site/subsite

how can show all permission under a subsite in share point.




How to ger share point sub site Ownr Name & Email using Object moel



i am sending request to the subsite owner so that time Current user like Requestor don't have permissions,but i need to send some information to owner.

Thanks & Regards


Content Type for Share Point Site



I am new to Share Point so just have 2-3 doubt need to clarify

1. How we enhance our Share point Out Box search using Content Type ?

2. The above operation is Possible in MOSS 2007 ?



sharepoint 2007 site external access


I am working on some code that I am writing on my dev site.  When you click a button, you are sent to a third party site, when you are done filling out a form, it kicks you back to my page.  This is done my referer.

On my test site, I created a site called test so if I go to http://test, my site comes up.  This won't work for my code development because the third party site must kick back to my site.  Since http://test isn't on the web, it won't work.

I set up a dyndns account so if you go to http://myhost.dyndns.org, the router points you to my vm.  If I go http://myhost.dyndns.org:5555, it goes to my central admin site.  If I go to http://myhost.dyndns.org, I get a random iis page, but not my sp site.


How do I change my sp2007 site, so I can access it from that other url?

Prompted for network credentials via internet while accessing SSRS reports in SharePoint integrated


We have developed a SharePoint- FBA site and published it through ISA.  The site, among many features, displays SSRS reports through Performance Point Monitoring dashboards.  SSRS is using windows integrated authentication (Kerberos).  Through intranet, the reports are getting displayed without any issue, but, through internet, its getting prompted when we try to access the reports for the first time after logging into the site using FBA credentials.  When we enter valid domain credentials after being prompted, it starts displaying reports without any issues and never prompts again for that FBA session.

We have been trying to eliminate the prompt through internet, but couldn't do so. 

Has anyone experienced the same before?

Any help is appreciated.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend