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

newbiw SQL 2K DBA

I come from Oracle DBA background and I know a little about SQL
serverand SQL Server EM. In a Production SQL Server environnmet:

1- How do you create a baseline for performance tuning?

2- How do you refresh Dev box from a large Production DB? 3- what's
the few main scripts you schedule or use everyday in sybase?

4- what's the main commnads to startup, shoudown and check thesql
server DB?

5- What's the main sp_ procs you use everyday?

6- How do you find and tune top 10 bad sqls?

7- what's the best forums to post questions and get quick answers?

8- what's the best 3 third party tools for sql server?

9- any sybase - oracle equivalent cheat sheet exist in internet
orbook?

10- what's the top 3 books you recommended?Many thanks for your time
and help"Frank" <soal6570@.yahoo.com> wrote in message
news:42601b2.0404031906.10ec61d0@.posting.google.co m...
> I come from Oracle DBA background and I know a little about SQL
> serverand SQL Server EM. In a Production SQL Server environnmet:
> 1- How do you create a baseline for performance tuning?
> 2- How do you refresh Dev box from a large Production DB? 3- what's
> the few main scripts you schedule or use everyday in sybase?
> 4- what's the main commnads to startup, shoudown and check thesql
> server DB?
> 5- What's the main sp_ procs you use everyday?
> 6- How do you find and tune top 10 bad sqls?
>
> 7- what's the best forums to post questions and get quick answers?
> 8- what's the best 3 third party tools for sql server?
> 9- any sybase - oracle equivalent cheat sheet exist in internet
> orbook?
>
> 10- what's the top 3 books you recommended?Many thanks for your time
> and help

You mention Sybase several times - are you working with Sybase or with
Microsoft SQL Server? Assuming you're using Microsoft's product, then here
are some quick answers:

1. Use a test database, make changes, test them, and use Profiler to see
what the difference is.

2. Backup/restore is easiest, but log shipping or replication might be
better if you have very large databases, and you want to copy the changes
incrementally or with a short delay.

3. That depends a lot on the environment, but backups and maintenance plans
are the obvious ones.

4. Start/stop with the NET START/STOP command, through Enterprise Manager,
or use any interface (eg. WMI) that can manipulate Windows services. I don't
know what you mean by 'check' the server, but see the DBCC commands in Books
Online, and also look at maintenance plans.

5. Too many to mention, but sp_who2 and sp_lock are very useful.

6. Use Profiler, and filter on query duration to find long-running
statements. Profiler can also display the execution plan.

7. Here, or the microsoft.public.sqlserver.* groups - there are groups for
specific areas such as .security, .xml, .replication etc.

8. That depends on what you want to do - the tools that come with the
product can do most things.

9. Assuming you mean Microsoft SQL Server, then here is one:

http://www.microsoft.com/resources/...art2/c0761.mspx

10. Books Online, Books Online and Books Online...

Simon|||Thanks a lot for answers. It was great specially the link you sent me.
Just few more questions:

1- What is the best practice for sizing a new Database and
configuration parameters? Any link for that or just a quick comment
from you? Do we have something like init.ora here?

2- I heard that you can write custom-scripts for admin and put them in
master database and access them for all db. Is that the way you can
cutom monitor the db? Can you send me a small example?

3- What is the top 5 troubleshooting and monitoring needs to be done
as a daily basis?

"Simon Hayes" <sql@.hayes.ch> wrote in message news:<40700624$1_3@.news.bluewin.ch>...
> "Frank" <soal6570@.yahoo.com> wrote in message
> news:42601b2.0404031906.10ec61d0@.posting.google.co m...
> > I come from Oracle DBA background and I know a little about SQL
> > serverand SQL Server EM. In a Production SQL Server environnmet:
> > 1- How do you create a baseline for performance tuning?
> > 2- How do you refresh Dev box from a large Production DB? 3- what's
> > the few main scripts you schedule or use everyday in sybase?
> > 4- what's the main commnads to startup, shoudown and check thesql
> > server DB?
> > 5- What's the main sp_ procs you use everyday?
> > 6- How do you find and tune top 10 bad sqls?
> > 7- what's the best forums to post questions and get quick answers?
> > 8- what's the best 3 third party tools for sql server?
> > 9- any sybase - oracle equivalent cheat sheet exist in internet
> > orbook?
> > 10- what's the top 3 books you recommended?Many thanks for your time
> > and help
> You mention Sybase several times - are you working with Sybase or with
> Microsoft SQL Server? Assuming you're using Microsoft's product, then here
> are some quick answers:
> 1. Use a test database, make changes, test them, and use Profiler to see
> what the difference is.
> 2. Backup/restore is easiest, but log shipping or replication might be
> better if you have very large databases, and you want to copy the changes
> incrementally or with a short delay.
> 3. That depends a lot on the environment, but backups and maintenance plans
> are the obvious ones.
> 4. Start/stop with the NET START/STOP command, through Enterprise Manager,
> or use any interface (eg. WMI) that can manipulate Windows services. I don't
> know what you mean by 'check' the server, but see the DBCC commands in Books
> Online, and also look at maintenance plans.
> 5. Too many to mention, but sp_who2 and sp_lock are very useful.
> 6. Use Profiler, and filter on query duration to find long-running
> statements. Profiler can also display the execution plan.
> 7. Here, or the microsoft.public.sqlserver.* groups - there are groups for
> specific areas such as .security, .xml, .replication etc.
> 8. That depends on what you want to do - the tools that come with the
> product can do most things.
> 9. Assuming you mean Microsoft SQL Server, then here is one:
> http://www.microsoft.com/resources/...art2/c0761.mspx
> 10. Books Online, Books Online and Books Online...
> Simon|||"Frank" <soal6570@.yahoo.com> wrote in message
news:42601b2.0404060339.d638dbd@.posting.google.com ...
> Thanks a lot for answers. It was great specially the link you sent me.
> Just few more questions:
> 1- What is the best practice for sizing a new Database and
> configuration parameters? Any link for that or just a quick comment
> from you? Do we have something like init.ora here?
> 2- I heard that you can write custom-scripts for admin and put them in
> master database and access them for all db. Is that the way you can
> cutom monitor the db? Can you send me a small example?
>
> 3- What is the top 5 troubleshooting and monitoring needs to be done
> as a daily basis?

<snip
1. As regards sizing, some of the big hardware vendors have sizing guides
for their own hardware, and Books Online has a section on estimating table
sizes. As for init.ora, the general MSSQL approach is that the database
server should be left to manage itself as much as possible - you can change
server-wide settings with sp_configure, but it's not something you should do
unless you really need to. One exception is memory, because MSSQL will take
all the memory on the box by default, so if you have other apps on the
server, you may need to limit how much memory MSSQL should use.

2. This is possible, but it's not really advised - Microsoft doesn't support
it. Which doesn't mean that no one does it, of course - see here for more
information:

http://www.winnetmag.com/Article/Ar...1044/41044.html

3. That depends very much on your enivronment, but monitoring backups,
maintenance jobs and failed logins are one task, as is dealing with
databases where the transaction log fills up. You can set alerts on most
conditions to get a notification and/or automatically run a script in
response.

Simon

Newbie?: Can This Be Done?- If so please direct

Hello NG
I have been working with Access for a Long Time - Am just now starting
to get my feet wet with SQL Server 2000 - We have a production database that
we have moved the tables to SQLServer and I have been creating stored
procedures to replicate some of the processes done on the access side - the
server does process extremely faster than access - Here is my problem I am
currently pulling info from SQL SERVER to Access once a w for wly
stats I want to create a stored procedure to process the wly stats and
push them to an access table upon request - we have multiple warehouses and
i would like to have the process coded once in sql and dump to the access
table based off a warehouse variable passed to the stored procedure - Can
SQLServer from a stored procedure export a recordset into a varible defined
Access Table?
TIAFAH
RandyIt sounds like DTS is what you're looking for. I don't know that I
would recommend this approach to an experienced SQL Server developer
because of its limitations, but in what you're asking for, it seems
ideal. Open Enterprise Manager, right-click your database, select
"Export Data" (it might be under a submenu), follow the wizard. I'm
pretty sure you can specify a stored procedure for the source. If I
remember correctly, you may also schedule the package to run at
intervals.
-Alan
Randy wrote:
> Hello NG
> I have been working with Access for a Long Time - Am just now starting
> to get my feet wet with SQL Server 2000 - We have a production database th
at
> we have moved the tables to SQLServer and I have been creating stored
> procedures to replicate some of the processes done on the access side - th
e
> server does process extremely faster than access - Here is my problem I am
> currently pulling info from SQL SERVER to Access once a w for wly
> stats I want to create a stored procedure to process the wly stats and
> push them to an access table upon request - we have multiple warehouses an
d
> i would like to have the process coded once in sql and dump to the access
> table based off a warehouse variable passed to the stored procedure - Can
> SQLServer from a stored procedure export a recordset into a varible define
d
> Access Table?
> TIAFAH
> Randy

newbie: logging for stored procs

ok when debugging a stored proc, yes i can see print output etc in sql
query analyzer. but when the proc is called in production, i dont see that
output; moreover, im new and wondering what are the typical ways that you
all log stuff from a stored proc, etc.
is something like this common?
http://www.databasejournal.com/feat...cle.php/1467591jimbo-black wrote:
> ok when debugging a stored proc, yes i can see print output etc in sql
> query analyzer. but when the proc is called in production, i dont
> see that output; moreover, im new and wondering what are the typical
> ways that you all log stuff from a stored proc, etc.
> is something like this common?
> http://www.databasejournal.com/feat...cle.php/1467591
Presumably, you have PRINT statements in procedures while they are in
development for debugging purposes and those PRINT statements are
removed for production. If what you need is a parameter-driven method to
execute a procedure with logging, then you can use conditional
statements in the procedure to log to a table as the article explains
(or even issue PRINT statements for interactive testing). In general,
though, it's better to do this type of work in development and keep your
procedure code to a minimum. For batch routines that might need to log
their lengthly processes and progress, a logging table would be the way
to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com

newbie: logging for stored procs

ok when debugging a stored proc, yes i can see print output etc in sql
query analyzer. but when the proc is called in production, i dont see that
output; moreover, im new and wondering what are the typical ways that you
all log stuff from a stored proc, etc.
is something like this common?
http://www.databasejournal.com/features/mssql/article.php/1467591jimbo-black wrote:
> ok when debugging a stored proc, yes i can see print output etc in sql
> query analyzer. but when the proc is called in production, i dont
> see that output; moreover, im new and wondering what are the typical
> ways that you all log stuff from a stored proc, etc.
> is something like this common?
> http://www.databasejournal.com/features/mssql/article.php/1467591
Presumably, you have PRINT statements in procedures while they are in
development for debugging purposes and those PRINT statements are
removed for production. If what you need is a parameter-driven method to
execute a procedure with logging, then you can use conditional
statements in the procedure to log to a table as the article explains
(or even issue PRINT statements for interactive testing). In general,
though, it's better to do this type of work in development and keep your
procedure code to a minimum. For batch routines that might need to log
their lengthly processes and progress, a logging table would be the way
to go.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

newbie: logging for stored procs

ok when debugging a stored proc, yes i can see print output etc in sql
query analyzer. but when the proc is called in production, i dont see that
output; moreover, im new and wondering what are the typical ways that you
all log stuff from a stored proc, etc.
is something like this common?
http://www.databasejournal.com/featu...le.php/1467591
jimbo-black wrote:
> ok when debugging a stored proc, yes i can see print output etc in sql
> query analyzer. but when the proc is called in production, i dont
> see that output; moreover, im new and wondering what are the typical
> ways that you all log stuff from a stored proc, etc.
> is something like this common?
> http://www.databasejournal.com/featu...le.php/1467591
Presumably, you have PRINT statements in procedures while they are in
development for debugging purposes and those PRINT statements are
removed for production. If what you need is a parameter-driven method to
execute a procedure with logging, then you can use conditional
statements in the procedure to log to a table as the article explains
(or even issue PRINT statements for interactive testing). In general,
though, it's better to do this type of work in development and keep your
procedure code to a minimum. For batch routines that might need to log
their lengthly processes and progress, a logging table would be the way
to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com