New Data-Driven Subscription option disabled

Question

New Data-Driven Subscription option disabled

kallal_nath

Mr or Mrs. 500

Points: 515
More actions
December 27, 2007 at 7:25 am

#180089

I am unable to find the "New Data-Driven Subscription"option in the subscription tab of report manager.I have gone through online help of SSRS where it's written that credentials should be securely stored in the report server.So i did accordingly and also used windows integrated authentication.But still I am unable to find the said option.Can anyone please help me out.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

You need the correct security in SSRS (making yourself an administrator will suffice for now). You also must be running the Enterprise Edition of Reporting Services.

Greg Edwards-268690 SSC-Insane Points: 20676 More actions · Answer 2

Michael is right - only Enterprise Edition and Developer Editions support data driven subscriptions.

Greg E

kallal_nath Mr or Mrs. 500 Points: 515 More actions · Answer 3

Thanks Michael and George.You are correct.I have either Mobile or Express edition of Sql Server 2005 as I've noticed somewhere in C:/Programfiles.Anyways can you tell me how to exactly find the edition of Sql Server 2005?

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 4

Run this query:

select @@version

it will give you some OS information, the SQL edition, and the version / service pack number.

kallal_nath Mr or Mrs. 500 Points: 515 More actions · Answer 5

Thanks Michael,I again have got the solution.Below is the ouput I got.

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Michael,I have one more query regarding Querying and Reporting on Report Execution Log Data.It is said that using the DTS package the contents of the Report Server Execution Log can be copied into a set of user-defined tables.The location of the DTS package as given in SQL Server 2005 Reporting Services Black Book is c:\Program Files\Microsoft SQL Server\80\Tools\Reporting Service\ExecutionLog.But i couldn't get the package instead I got some Package folder in c:\Program Files\Microsoft SQL Server\90\DTS\Packages. I also got in technet.microsoft.com the following:

"A sample database script file is provided that creates the table structure used by the package. The following files are used to create the database and extract data:

RSExecutionLog_Update.dtsx

RSExecutionLog_Update.dtsConfig

Createtables.sql"

But I am unable to find the above anywhere.So Michael could you please help me in resolving this issue.

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 6

I have never used the default reporting that they are talking about. I also do not have the folder specified. My guess is that it is installed with some of the sample projects if you install them when doing your SQL install.

If you did not install the sample databases and all sample code and developer tools, you may have to go back and do this to get the folder the book is referring to.

You could also just search for the file names on the SQL Server install DVD - it may be possible to just copy these files from the install disks.

kallal_nath Mr or Mrs. 500 Points: 515 More actions · Answer 7

Thanks Michael for your guidance.I really don't have those folders in program files.I guess they got missed out at the time of installation.