Report subscription in SSRS with sharepoint
Hi, Problem Statement: I am trying to create an SSRS report subscription for email through rs.exe utility by creating a .rss file. the end point which is used to subscribe the report is MGMT2010. Given below is the command that i am executing on my development environment for creating a subscription for the report using rs.exe utility - C:\>rs -i C:\TestSub.rss -s http://servername/reportserver_mssqlserver2008 -e mgmt2005 When i execute this command, i get"The command completed successfully" message without any error and the report subscription appears in the my subscription section of the report manager. We have SQL Server 2008 R2 installed in native mode in our development environment. Every thing is working just fine on the development environment. But the problem occures when i try to do this on the production environment, where i have SSRS installed in "Sharepoint Integrated Mode".The command that i am trying to execute is C:\>rs -i C:\TestSub.rss -s http://servername/reportserver_mssqlserver2008 -e mgmt2010 Here also the command executes successfully and an entry is being added in Subscriptions and Schedules table in the "ReportServer" Database. The problem what i am facing here is that even if the entry is being added in the above mentioned tables of the "ReportServer" database, the "manage subscription" option is not displaying the subscription. Can somebody let me know what am I missing here?
January 16th, 2012 1:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics