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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SSRS integrated mode email subscription to AD dist group

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
 
I have MOSS 2007 running SQL 2008 SSRS integrated mode and have created some reports and report subscriptions. Everything is working great. Now I want to use an Active Directory Distribution Group as a recipient for a report subscription - does not work, however the "last results" show no error. Try again using Dist Group in TO: field but adding regular email in CC: field...only email in CC field receive report, again all successful. Does SSRS integrated mode support AD distribution groups? if so is there any special setup required? Thanks LmmMmmm...yummy...


View Complete Post


More Related Resource Links

Setting Title on SSRS (SharePoint Integrated Mode) subscription.

  
I have some subscriptions in SSRS where the report goes directly to a Document Library on Sharepoint.  The subscription works fine, however, I would like to have the Title of the report be the current date that the report is run.  Is there a way to put a formula such as =[today] in the Title field of the File Options section on the Subscription properties?  I have tried this but either it is not possible or I am not using the correct syntax.  Thanks, Tim Olig

Reporting Services Integrated mode 2008 R2 Subscription Email Error

  

I have setup report subscriptions delivered via email,  on Sharepoint and they tend to fail sending email randomly. It works most of the time, once or twice a week few subscriptions fail. Here is the detailed error message:

library!WindowsService_28!a74!05/18/2011-06:45:12:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. Logon failed for the unattended execution account. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception: The security database on the server does not have a computer account for this workstation trust relationship

library!WindowsService_28!550!05/18/2011-06:45:12:: i INFO: Schedule 7d92afd5-f5ac-4d65-adc8-d87a3aa4bef4 executed at 05/18/2011 06:45:12.

schedule!WindowsService_28!550!05/18/2011-06:45:12:: Creating Time based subscription notification for subscription: 7f035fad-44a1-4cd6-9d41-5465540c879d

Sharepoint and SSRS Sharepoint integrated mode, any side effect ?

  
Hi, We planned to switch from native mode to sharepoint integrated mode our SQL Server Reporting Server. But it is a production server, so we liked to know if any side effect can happened on existing report and if it is possible to switch an existing database into sharepoint integrated mode ? Thanks, Mathieu Perrin.

SSRS Integrated: Program Subscription Building?

  
We have a few hundred clients, and we need to run a daily sql report for each of them. Saved in a document library, they can be picked up by the Search. I'd like to avoid the manual work of setting up 200+ report subscriptions. What would be the recommended route?1) Work with the sql 2008 object model?2) Work with the MOSS object model? (I see no class methods available for this - is this even possible?)3) Work directly with either the report server database or the sharepoint database and with ado.net just loop through a set of insert statements, one for each client we want a report for?Thanks for any input/direction.markusMarlin7

Drill down issues with ssrs in integrated mode

  
The "jump to report" drilldown option is not working right.  These same reports drill fine on another report server (non-integrated).  It looks like the "path" specified in the url is messed up, it's trying to go to site/subsite/report instead of just subsite/report.  The site that has the report library is not the root site in the site collection. I've tried looking around for a setting for that path but I don't see it.  Seems like the report would know its own path.. Thanks in advance for your help,   Ken SSRS 2005, MOSS 2007

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

  
I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

SSRS 2005 Standard - Subscription to email distribution list?

  

Hello,

    I am delivering SSRS 2005 reports via email subscription. I would like to utilize distribution lists. However, we do not have an exchange server. Is there a way to create distribution lists on the server that can then be accessed through SSRS Standard?

Thanks,

    Wayne


SSRS 2008 - email subscription - 7 minute delay between two reports emailed out (normally less than

  

We have a report subscription that emails out through a 3rd / separate smtp server.

I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed a long pause between updates about half way through the subscription.

 

It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479, etc...)

 

So I quer

Pass delivery method, email address to create SSRS subscription using VS2005

  

Hi,

I have created SSRS reports and built a user UI to run these reports. Now when creating SSRS subscriptions in report Manager, is it even possible to programmatically pass the delivery method (email or file share), To email address, scheduled time and date, etc from my front-end UI to the Report Manager?

Any help will be greatly appreciated. Thanks


SSRS 2005 Email Address Disappears when Editing Subscription

  

I have users that are editing their own SSRS E-Mail Subscriptions.  When they choose "Email" from the Delivered By combo box and type in a e-mail address it disappears after they set a schedule using the "Select Schedule" button and.

Any ideas?


ssrs and sharepoint 2010 integrated mode

  

 

Hello,

 

I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.

 

 

 

Webpage error details

 

 

 

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)

 

Timestamp: Wed, 20 Oct 2010 14:52:43 UTC

 

 

 

 

 

Message: 'null' is null or not an object

 

Line: 5

 

Char: 27772

 

Code: 0

 

URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e

 

 

 


Installation of SSRS 2008 in SharePoint integrated mode

  
Hi All,

I have got a server (Windows Server 2003 x64) which has the Office SharePoint server 2007 and SQL Server Reporting Services 2008 (in SharePoint Integrated mode) installed in a stand-alone machine (System configured and installed by some other guy). We want to use the SSRS 2008 in SharePoint integrated mode.

I want to make sure that installation and configuration of system is done properly. But i am a starter, so i don't know much where to start.

Please help me which points i have to check to make sure that system is configured properly.

Also i visited the server and found the followings:
1. In central administration, under Application Management tab, Report Services section is not there. ( I think SSRS 2008 AddIn is not installed)
2. Single MSSSQLServer is created for SQL Server 2008, SSRS 2008 and Office SharePoint Server 2007 (Not sure Please let me know where i can confirm this)

Any help is appreciated.

3.

Thanks, Cool Developer

Subscription problems, SharePoint and MOSS 2007 in Integrated Mode

  

This does not happen all the time, in fact about 5% of the time, but here's the error message when trying to "manage subscriptions" for an SSRS report:  Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Troubleshoot issues with Windows SharePoint Services.

Now if I send a copy of the report to file, rename it, upload it again, and try again -- then the error message usually goes away.  In short, intermittently the subscription capability goes away for a given report and then only way to get it back is to delete the report and re-upload it under a slightly different name.


ssrs and sharepoint 2010 integrated mode

  

Hello,

I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.

 

Webpage error details

 

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)

Timestamp: Wed, 20 Oct 2010 14:52:43 UTC

 

 

Message: 'null' is null or not an object

Line: 5

Char: 27772

Code: 0

URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e

 

Can somebody please tell me whats happening.

 


500 Error generating SSRS Report in SharePoint Integrated Mode

  

Our environment looks as follows:

- MOSS 2007 Site/Central Admin (Enterprise) on Server A

- SQL Reporting Services 2008 R2 on Server B

- Report created on workstation using Report Builder 3.0

- SharePoint Library (with Promoted InfoPath fields) is the XML datasource

 

The report generates perfectly fine in development, but once loading the RDL up to the SP Site we get the following error when trying to view:

 

An error occurred during client rendering.

The remote server returned an error: (500) Internal Server Error.

 

Using this generic information we have checked into numerous apparent fixes, from confirming settings in the Central Admin, to changing the Zone Authentication to NTLM, to ensuring Anonymous Access is disabled, as well as some tweaks in IIS, etc.

We're still not having any luck getting the report to generate.

Any assistance would be greatly appreciated.


SSRS SharePoint Integrated Mode

  

Hi Everyone,

We have an SSRS instance under SharePoint Integrated Mode. I just want to know what my options are for deploying SSRS reports. Would it be ok if I don't install SharePoint on the SSRS box? SSRS and SharePoint are on different hardware. Please advise.

Thanks in advance.

 


Upgrade from SQL Server 2005 to SQL Server 2008 from SharePoint 2007 SSRS 2005 integrated mode

  

I"m attempting to upgrade from SQL Server 2005 to SQL Server 2008 R2 x64 Enterprise on a server running Windows Server 2003 x64 Enterprise, SharePoint 2007 Enterprise, and SQL Server 2005 and SSRS 2005 Enterprise running in integrated mode.

I installed the Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en.

When attempting to install Report Builder 2.0, I get the error "Reporting Services Add-in for SharePoint products and technologies is not installed."

When I try to run a report (existing 2005 reports already deployed), I get the error: "Operation is not valid due to the current state of the object." The log has repeating ReportingServicesService.exe errors: #20015: Cannot open "Resources.en-US.resx": no such file or folder, and: Localized resource for token 'ManageDatasetCaching_Desc' could not be found for file with path: "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Features\ReportServer\ItemCustomActions\ecbExtension.xml" among other things.

I've tried rec

Categories: 
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