SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


New Data-Driven Subscription option disabled


New Data-Driven Subscription option disabled

Author
Message
kallal_nath
kallal_nath
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 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.
Michael Earl-395764
Michael Earl-395764
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4975 Visits: 23078
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
Greg Edwards-268690
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1566 Visits: 8493
Michael is right - only Enterprise Edition and Developer Editions support data driven subscriptions.
Greg E
kallal_nath
kallal_nath
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 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?
Michael Earl-395764
Michael Earl-395764
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4975 Visits: 23078
Run this query:

select @@version

it will give you some OS information, the SQL edition, and the version / service pack number.
kallal_nath
kallal_nath
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 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.
Michael Earl-395764
Michael Earl-395764
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4975 Visits: 23078
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
kallal_nath
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search