Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

New Data-Driven Subscription option disabled Expand / Collapse
Author
Message
Posted Thursday, December 27, 2007 7:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2008 5:41 AM
Points: 7, Visits: 37
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.
Post #436654
Posted Friday, December 28, 2007 6:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
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.
Post #437019
Posted Friday, December 28, 2007 6:28 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 10:28 AM
Points: 680, Visits: 6,863
Michael is right - only Enterprise Edition and Developer Editions support data driven subscriptions.
Greg E
Post #437021
Posted Wednesday, January 16, 2008 3:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2008 5:41 AM
Points: 7, Visits: 37
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?
Post #443486
Posted Wednesday, January 16, 2008 4:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
Run this query:

select @@version

it will give you some OS information, the SQL edition, and the version / service pack number.
Post #443534
Posted Wednesday, January 16, 2008 6:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2008 5:41 AM
Points: 7, Visits: 37
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
Copyright (c) 1988-2005 Microsoft Corporation
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.
Post #443553
Posted Wednesday, January 16, 2008 7:24 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
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.
Post #443629
Posted Wednesday, January 16, 2008 9:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2008 5:41 AM
Points: 7, Visits: 37
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.
Post #444118
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse