Monday, March 26, 2012

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 comments:

Post a Comment