No Data-Driven Subscription Button

Hi,
I have a test server and a production RS server. On the test server I can
create data-driven subscriptions with no problems. However, on the
production server I do not get the "New Data-Driven Subscription" button and
I can't figure out why.
- I'm a domain administrator so I have local admin rights on both boxes.
- I'm Content Manager on both boxes
- The Config files look identical (impersonate is on for both of them,
however the connection string is encrypted so it could be that it's running
under a user without priveleges.)
- I'm not using integrated security for the data sources
- The data sources are shared. I found this on MSDN: "This button is not
available when you access subscriptions through a shared data source", but
the development server works okay with a shared data source, and even when I
switch a report over to use a non-shared (custom) data source the button is
not availab.e
- The ReportServer's are running under the same account
Obviously I'm missing something. Any ideas?
Thx, JoelAre you sure the production server has the Enterprise Edition of Reporting
Services installed? Data-driven subscriptions are not available in the
Standard Edition.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a test server and a production RS server. On the test server I can
> create data-driven subscriptions with no problems. However, on the
> production server I do not get the "New Data-Driven Subscription" button
and
> I can't figure out why.
> - I'm a domain administrator so I have local admin rights on both boxes.
> - I'm Content Manager on both boxes
> - The Config files look identical (impersonate is on for both of them,
> however the connection string is encrypted so it could be that it's
running
> under a user without priveleges.)
> - I'm not using integrated security for the data sources
> - The data sources are shared. I found this on MSDN: "This button is not
> available when you access subscriptions through a shared data source", but
> the development server works okay with a shared data source, and even when
I
> switch a report over to use a non-shared (custom) data source the button
is
> not availab.e
> - The ReportServer's are running under the same account
>
> Obviously I'm missing something. Any ideas?
> Thx, Joel
>|||That's probably it ...
how can I tell which version I'm running? Is there a query or a setting in
the config files?
Thx, Joel
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Are you sure the production server has the Enterprise Edition of Reporting
> Services installed? Data-driven subscriptions are not available in the
> Standard Edition.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> I have a test server and a production RS server. On the test server I can
>> create data-driven subscriptions with no problems. However, on the
>> production server I do not get the "New Data-Driven Subscription" button
> and
>> I can't figure out why.
>> - I'm a domain administrator so I have local admin rights on both boxes.
>> - I'm Content Manager on both boxes
>> - The Config files look identical (impersonate is on for both of them,
>> however the connection string is encrypted so it could be that it's
> running
>> under a user without priveleges.)
>> - I'm not using integrated security for the data sources
>> - The data sources are shared. I found this on MSDN: "This button is not
>> available when you access subscriptions through a shared data source",
>> but
>> the development server works okay with a shared data source, and even
>> when
> I
>> switch a report over to use a non-shared (custom) data source the button
> is
>> not availab.e
>> - The ReportServer's are running under the same account
>>
>> Obviously I'm missing something. Any ideas?
>> Thx, Joel
>>
>|||Just check under Control Panel : Add/Remove Programs. It should say
"Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
> That's probably it ...
> how can I tell which version I'm running? Is there a query or a setting in
> the config files?
> Thx, Joel
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
> > Are you sure the production server has the Enterprise Edition of
Reporting
> > Services installed? Data-driven subscriptions are not available in the
> > Standard Edition.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
> >> Hi,
> >>
> >> I have a test server and a production RS server. On the test server I
can
> >> create data-driven subscriptions with no problems. However, on the
> >> production server I do not get the "New Data-Driven Subscription"
button
> > and
> >> I can't figure out why.
> >>
> >> - I'm a domain administrator so I have local admin rights on both
boxes.
> >> - I'm Content Manager on both boxes
> >> - The Config files look identical (impersonate is on for both of them,
> >> however the connection string is encrypted so it could be that it's
> > running
> >> under a user without priveleges.)
> >> - I'm not using integrated security for the data sources
> >> - The data sources are shared. I found this on MSDN: "This button is
not
> >> available when you access subscriptions through a shared data source",
> >> but
> >> the development server works okay with a shared data source, and even
> >> when
> > I
> >> switch a report over to use a non-shared (custom) data source the
button
> > is
> >> not availab.e
> >> - The ReportServer's are running under the same account
> >>
> >>
> >> Obviously I'm missing something. Any ideas?
> >>
> >> Thx, Joel
> >>
> >>
> >
> >
>|||So it's definitely Standard Edition which explains that.
Next question: is Sql Server Enterprise Edition required to have Reporting
Services Enterprise Edition installed or are they mutually exclusive? I
currently only have servers with Sql Server Standard Edition.
Thanks for the replies so far.
-Joel
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Just check under Control Panel : Add/Remove Programs. It should say
> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a setting
>> in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
> Reporting
>> > Services installed? Data-driven subscriptions are not available in the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server I
> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button is
> not
>> >> available when you access subscriptions through a shared data source",
>> >> but
>> >> the development server works okay with a shared data source, and even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>|||Looks like the editions must match.
" The edition of SQL RS that can be installed must correspond to the
edition of SQL Server that is installed : "
http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
Why not include data driven subscriptions in the SE version of SRS? It seems
to be a basic element. Although, I understand it will drive some purchases
of Sql Server EE.
Thx, Joel
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> So it's definitely Standard Edition which explains that.
> Next question: is Sql Server Enterprise Edition required to have Reporting
> Services Enterprise Edition installed or are they mutually exclusive? I
> currently only have servers with Sql Server Standard Edition.
> Thanks for the replies so far.
> -Joel
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a setting
>> in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>|||Technically, this is the case only if you want to install them on the same
box. You can buy an EE license of SQL Server to run Reporting Services and
connect to an external STD SQL relational database.
Anyawy, we had to make some decisions about what would go in each edition.
After talking to customers, data driven subscriptions seemed like a
reasonable EE feature.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:OiWkmPR7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Looks like the editions must match.
> " The edition of SQL RS that can be installed must correspond to the
> edition of SQL Server that is installed : "
> http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
> Why not include data driven subscriptions in the SE version of SRS? It
> seems to be a basic element. Although, I understand it will drive some
> purchases of Sql Server EE.
> Thx, Joel
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> So it's definitely Standard Edition which explains that.
>> Next question: is Sql Server Enterprise Edition required to have
>> Reporting Services Enterprise Edition installed or are they mutually
>> exclusive? I currently only have servers with Sql Server Standard
>> Edition.
>> Thanks for the replies so far.
>> -Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a setting
>> in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in
>> > the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server
>> >> I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and
>> >> even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>>
>|||Thanks for the clarification.
Technically speaking, I could request a SRS EE cd, install it, and then
point it to a STD Edition Sql Server (on another machine). But, to do this,
an Sql Server EE license is required, although Sql Server EE wouldn't
necessarily need to be installed.
The pricing info for a Sql Server EE license is the same as purchasing the
software correct?
Thanks!!
Joel
"Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
news:eP6t6lR7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Technically, this is the case only if you want to install them on the same
> box. You can buy an EE license of SQL Server to run Reporting Services and
> connect to an external STD SQL relational database.
> Anyawy, we had to make some decisions about what would go in each edition.
> After talking to customers, data driven subscriptions seemed like a
> reasonable EE feature.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
> news:OiWkmPR7EHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Looks like the editions must match.
>> " The edition of SQL RS that can be installed must correspond to the
>> edition of SQL Server that is installed : "
>> http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
>> Why not include data driven subscriptions in the SE version of SRS? It
>> seems to be a basic element. Although, I understand it will drive some
>> purchases of Sql Server EE.
>> Thx, Joel
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> So it's definitely Standard Edition which explains that.
>> Next question: is Sql Server Enterprise Edition required to have
>> Reporting Services Enterprise Edition installed or are they mutually
>> exclusive? I currently only have servers with Sql Server Standard
>> Edition.
>> Thanks for the replies so far.
>> -Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a
>> setting in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in
>> > the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test server
>> >> I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button
>> >> is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and
>> >> even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>>
>>
>|||You are correct. RS is part of the SQL Server license so you are buying a
license even if you don't install the relational database component.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
news:Ot1B9iS7EHA.1596@.tk2msftngp13.phx.gbl...
> Thanks for the clarification.
> Technically speaking, I could request a SRS EE cd, install it, and then
> point it to a STD Edition Sql Server (on another machine). But, to do
> this, an Sql Server EE license is required, although Sql Server EE
> wouldn't necessarily need to be installed.
> The pricing info for a Sql Server EE license is the same as purchasing the
> software correct?
> Thanks!!
> Joel
>
> "Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
> news:eP6t6lR7EHA.3616@.TK2MSFTNGP11.phx.gbl...
>> Technically, this is the case only if you want to install them on the
>> same box. You can buy an EE license of SQL Server to run Reporting
>> Services and connect to an external STD SQL relational database.
>> Anyawy, we had to make some decisions about what would go in each
>> edition. After talking to customers, data driven subscriptions seemed
>> like a reasonable EE feature.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:OiWkmPR7EHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Looks like the editions must match.
>> " The edition of SQL RS that can be installed must correspond to the
>> edition of SQL Server that is installed : "
>> http://msmvps.com/anguslogan/archive/2004/10/03/14788.aspx
>> Why not include data driven subscriptions in the SE version of SRS? It
>> seems to be a basic element. Although, I understand it will drive some
>> purchases of Sql Server EE.
>> Thx, Joel
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:OrhblKR7EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> So it's definitely Standard Edition which explains that.
>> Next question: is Sql Server Enterprise Edition required to have
>> Reporting Services Enterprise Edition installed or are they mutually
>> exclusive? I currently only have servers with Sql Server Standard
>> Edition.
>> Thanks for the replies so far.
>> -Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:u6eE59Q7EHA.2540@.TK2MSFTNGP09.phx.gbl...
>> Just check under Control Panel : Add/Remove Programs. It should say
>> "Microsoft SQL Server 2000 Reporting Services Enterprise Edition".
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> news:uasoRaQ7EHA.2804@.TK2MSFTNGP15.phx.gbl...
>> That's probably it ...
>> how can I tell which version I'm running? Is there a query or a
>> setting in
>> the config files?
>> Thx, Joel
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
>> message
>> news:uPD54tI7EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > Are you sure the production server has the Enterprise Edition of
>> Reporting
>> > Services installed? Data-driven subscriptions are not available in
>> > the
>> > Standard Edition.
>> >
>> > --
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Joel Rumerman" <JRumerman@.prometheuslabs.com> wrote in message
>> > news:%23n8mtuH7EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> >> Hi,
>> >>
>> >> I have a test server and a production RS server. On the test
>> >> server I
>> can
>> >> create data-driven subscriptions with no problems. However, on the
>> >> production server I do not get the "New Data-Driven Subscription"
>> button
>> > and
>> >> I can't figure out why.
>> >>
>> >> - I'm a domain administrator so I have local admin rights on both
>> boxes.
>> >> - I'm Content Manager on both boxes
>> >> - The Config files look identical (impersonate is on for both of
>> >> them,
>> >> however the connection string is encrypted so it could be that
>> >> it's
>> > running
>> >> under a user without priveleges.)
>> >> - I'm not using integrated security for the data sources
>> >> - The data sources are shared. I found this on MSDN: "This button
>> >> is
>> not
>> >> available when you access subscriptions through a shared data
>> >> source",
>> >> but
>> >> the development server works okay with a shared data source, and
>> >> even
>> >> when
>> > I
>> >> switch a report over to use a non-shared (custom) data source the
>> button
>> > is
>> >> not availab.e
>> >> - The ReportServer's are running under the same account
>> >>
>> >>
>> >> Obviously I'm missing something. Any ideas?
>> >>
>> >> Thx, Joel
>> >>
>> >>
>> >
>> >
>>
>>
>>
>>
>>
>

No Data-Driven Subscription button

I have created a report and published it on the reporting server. My connection is working, and I have followed the steps in the BOL tutorial for "Defining a Data-Driven Subscription" i.e. Credentials stored securely on report server, using windows credentials when connecting to the data source. When I click on "Subscriptions", I only see "New Subscriptions". However, when I look at other reports (not even created by me), I see the option to create data driven subscriptions. Can somebody tell me what I need to do to see this?I got it; the report cannot be in the "My Reports" folder.

No "From" field on the subscriptions page

We are starting to use data-driven subscriptions for multiple applications
and would like to change the From address for each subscription. There isn't
a "From" field on the "Delivery extension settings for Report Server Email"
page in the Data-driven subscriptions section of Reporting Manager. Let me
know if you've found a solution.
I don't get why the "From" field wasn't included in the interface;
especially, if it is walking across smtp.
--
Any and all contributions are greatly appreciated ...
Regards TJHello,
"Delivery extension settings" does not include "From" settings. This email
address is configured under
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer
You can find search "administrator@." to find the From settings under Report
Server Email settings.
Hope this helps.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
--
| From: "TJ" <nospam@.nowhere.com>
| Subject: No "From" field on the subscriptions page
| Date: Thu, 14 Oct 2004 17:02:09 -0400
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 38.116.25.196
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14|||Thanks and yes I see the From setting, but that doesn't tell me how each
report can have its own From setting. Please advise.
We would like to configure the system to have .
Billing Reports should come from "BillingServer"
HR Reports should come from "HR"
Thanks again
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
> Hello,
> "Delivery extension settings" does not include "From" settings. This email
> address is configured under
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer
> You can find search "administrator@." to find the From settings under
Report
> Server Email settings.
> Hope this helps.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> --
> | From: "TJ" <nospam@.nowhere.com>
> | Subject: No "From" field on the subscriptions page
> | Date: Thu, 14 Oct 2004 17:02:09 -0400
> | Lines: 14
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 38.116.25.196
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:32194
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | We are starting to use data-driven subscriptions for multiple
applications
> | and would like to change the From address for each subscription. There
> isn't
> | a "From" field on the "Delivery extension settings for Report Server
> Email"
> | page in the Data-driven subscriptions section of Reporting Manager. Let
me
> | know if you've found a solution.
> |
> | I don't get why the "From" field wasn't included in the interface;
> | especially, if it is walking across smtp.
> |
> | --
> | Any and all contributions are greatly appreciated ...
> | Regards TJ
> |
> |
> |
>|||Hello,
Thank you for your reply. Based on my research, Report server e-mail
delivery extension built in Reporting service does not support this feature
for now. You may need to develop customized e-mail delivery extension. I
have incuded the following articles for your reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_extend_deliver_66xy.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_ref_soapapi_service_ak_1xfd.asp
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/de
fault.aspx
Also, In addition, you are welcome to send suggestions for product
enhancements that you would like to see in
future versions of Microsoft products to us by submitting MS Wish at
MSWISH@.microsoft.com
Best Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "TJ" <nospam@.nowhere.com>
| References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
<xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
| Subject: Re: No "From" field on the subscriptions page
| Date: Fri, 15 Oct 2004 10:54:31 -0400
| Lines: 75
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 38.116.25.196
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:32262
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks and yes I see the From setting, but that doesn't tell me how each
| report can have its own From setting. Please advise.
|
| We would like to configure the system to have .
| Billing Reports should come from "BillingServer"
| HR Reports should come from "HR"
|
| Thanks again
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
| > Hello,
| >
| > "Delivery extension settings" does not include "From" settings. This
email
| > address is configured under
| >
| > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
| > Services\ReportServer\RSReportServer
| >
| > You can find search "administrator@." to find the From settings under
| Report
| > Server Email settings.
| >
| > Hope this helps.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > --
| > | From: "TJ" <nospam@.nowhere.com>
| > | Subject: No "From" field on the subscriptions page
| > | Date: Thu, 14 Oct 2004 17:02:09 -0400
| > | Lines: 14
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| > | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 38.116.25.196
| > | Path:
| >
|
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
| > phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
| microsoft.public.sqlserver.reportingsvcs:32194
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | We are starting to use data-driven subscriptions for multiple
| applications
| > | and would like to change the From address for each subscription. There
| > isn't
| > | a "From" field on the "Delivery extension settings for Report Server
| > Email"
| > | page in the Data-driven subscriptions section of Reporting Manager.
Let
| me
| > | know if you've found a solution.
| > |
| > | I don't get why the "From" field wasn't included in the interface;
| > | especially, if it is walking across smtp.
| > |
| > | --
| > | Any and all contributions are greatly appreciated ...
| > | Regards TJ
| > |
| > |
| > |
| >
|
|
||||Thanks for your help.
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:G7IjqsOtEHA.836@.cpmsftngxa06.phx.gbl...
> Hello,
> Thank you for your reply. Based on my research, Report server e-mail
> delivery extension built in Reporting service does not support this
feature
> for now. You may need to develop customized e-mail delivery extension. I
> have incuded the following articles for your reference:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_extend_deliver_66xy.asp
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
> rsp_ref_soapapi_service_ak_1xfd.asp
>
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/de
> fault.aspx
> Also, In addition, you are welcome to send suggestions for product
> enhancements that you would like to see in
> future versions of Microsoft products to us by submitting MS Wish at
> MSWISH@.microsoft.com
> Best Regards,
> Peter Yang
> MCSE2000, MCSA, MCDBA
> Microsoft Partner Online Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> | From: "TJ" <nospam@.nowhere.com>
> | References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
> <xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
> | Subject: Re: No "From" field on the subscriptions page
> | Date: Fri, 15 Oct 2004 10:54:31 -0400
> | Lines: 75
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | Message-ID: <uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 38.116.25.196
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:32262
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Thanks and yes I see the From setting, but that doesn't tell me how each
> | report can have its own From setting. Please advise.
> |
> | We would like to configure the system to have .
> | Billing Reports should come from "BillingServer"
> | HR Reports should come from "HR"
> |
> | Thanks again
> |
> | "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
> | news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
> | > Hello,
> | >
> | > "Delivery extension settings" does not include "From" settings. This
> email
> | > address is configured under
> | >
> | > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> | > Services\ReportServer\RSReportServer
> | >
> | > You can find search "administrator@." to find the From settings under
> | Report
> | > Server Email settings.
> | >
> | > Hope this helps.
> | >
> | > Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > --
> | > | From: "TJ" <nospam@.nowhere.com>
> | > | Subject: No "From" field on the subscriptions page
> | > | Date: Thu, 14 Oct 2004 17:02:09 -0400
> | > | Lines: 14
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | > | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: 38.116.25.196
> | > | Path:
> | >
> |
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
> | > phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> | microsoft.public.sqlserver.reportingsvcs:32194
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | We are starting to use data-driven subscriptions for multiple
> | applications
> | > | and would like to change the From address for each subscription.
There
> | > isn't
> | > | a "From" field on the "Delivery extension settings for Report Server
> | > Email"
> | > | page in the Data-driven subscriptions section of Reporting Manager.
> Let
> | me
> | > | know if you've found a solution.
> | > |
> | > | I don't get why the "From" field wasn't included in the interface;
> | > | especially, if it is walking across smtp.
> | > |
> | > | --
> | > | Any and all contributions are greatly appreciated ...
> | > | Regards TJ
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>|||Welcome!
Best Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "TJ" <nospam@.nowhere.com>
| References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
<xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
<uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
<G7IjqsOtEHA.836@.cpmsftngxa06.phx.gbl>
| Subject: Re: No "From" field on the subscriptions page
| Date: Tue, 19 Oct 2004 17:44:41 -0400
| Lines: 153
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OtQMYTitEHA.3604@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 38.116.25.196
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:32558
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks for your help.
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:G7IjqsOtEHA.836@.cpmsftngxa06.phx.gbl...
| > Hello,
| >
| > Thank you for your reply. Based on my research, Report server e-mail
| > delivery extension built in Reporting service does not support this
| feature
| > for now. You may need to develop customized e-mail delivery extension.
I
| > have incuded the following articles for your reference:
| >
| >
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
| > rsp_prog_extend_deliver_66xy.asp
| >
| >
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
| > rsp_ref_soapapi_service_ak_1xfd.asp
| >
| >
|
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/de
| > fault.aspx
| >
| > Also, In addition, you are welcome to send suggestions for product
| > enhancements that you would like to see in
| >
| > future versions of Microsoft products to us by submitting MS Wish at
| > MSWISH@.microsoft.com
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000, MCSA, MCDBA
| > Microsoft Partner Online Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > When responding to posts, please "Reply to Group" via
| > your newsreader so that others may learn and benefit
| > from your issue.
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| >
| > --
| > | From: "TJ" <nospam@.nowhere.com>
| > | References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| > <xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
| > | Subject: Re: No "From" field on the subscriptions page
| > | Date: Fri, 15 Oct 2004 10:54:31 -0400
| > | Lines: 75
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| > | Message-ID: <uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 38.116.25.196
| > | Path:
| >
|
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
| > phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
| microsoft.public.sqlserver.reportingsvcs:32262
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Thanks and yes I see the From setting, but that doesn't tell me how
each
| > | report can have its own From setting. Please advise.
| > |
| > | We would like to configure the system to have .
| > | Billing Reports should come from "BillingServer"
| > | HR Reports should come from "HR"
| > |
| > | Thanks again
| > |
| > | "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| > | news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
| > | > Hello,
| > | >
| > | > "Delivery extension settings" does not include "From" settings. This
| > email
| > | > address is configured under
| > | >
| > | > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
| > | > Services\ReportServer\RSReportServer
| > | >
| > | > You can find search "administrator@." to find the From settings under
| > | Report
| > | > Server Email settings.
| > | >
| > | > Hope this helps.
| > | >
| > | > Regards,
| > | >
| > | > Peter Yang
| > | > MCSE2000/2003, MCSA, MCDBA
| > | > Microsoft Online Partner Support
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | >
| > | > --
| > | > | From: "TJ" <nospam@.nowhere.com>
| > | > | Subject: No "From" field on the subscriptions page
| > | > | Date: Thu, 14 Oct 2004 17:02:09 -0400
| > | > | Lines: 14
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| > | > | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | NNTP-Posting-Host: 38.116.25.196
| > | > | Path:
| > | >
| > |
| >
|
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
| > | > phx.gbl
| > | > | Xref: cpmsftngxa10.phx.gbl
| > | microsoft.public.sqlserver.reportingsvcs:32194
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > |
| > | > | We are starting to use data-driven subscriptions for multiple
| > | applications
| > | > | and would like to change the From address for each subscription.
| There
| > | > isn't
| > | > | a "From" field on the "Delivery extension settings for Report
Server
| > | > Email"
| > | > | page in the Data-driven subscriptions section of Reporting
Manager.
| > Let
| > | me
| > | > | know if you've found a solution.
| > | > |
| > | > | I don't get why the "From" field wasn't included in the interface;
| > | > | especially, if it is walking across smtp.
| > | > |
| > | > | --
| > | > | Any and all contributions are greatly appreciated ...
| > | > | Regards TJ
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|