New Subscriptions Not Running

Hello,
I am running Microsoft SQL Server 2000.
For some reason all of the sudden any subscription I make in reporting
services will not run.
The status just stays at "New Subscription". I made a test schedule
that runs every 5 minutes.
I have even added old subscriptions to this schedule and I get email
every 5 minutes. Why would any new subscription I make not be running?
I don't even get an error message under the status heading in the
subscription list.
Thanks,
JeffJeffrae wrote:
> Hello,
> I am running Microsoft SQL Server 2000.
> For some reason all of the sudden any subscription I make in reporting
> services will not run.
> The status just stays at "New Subscription". I made a test schedule
> that runs every 5 minutes.
> I have even added old subscriptions to this schedule and I get email
> every 5 minutes. Why would any new subscription I make not be running?
>
> I don't even get an error message under the status heading in the
> subscription list.
>
> Thanks,
> Jeff
Ok... Here is something that I forgot to mention.. This is actually a
big thing.. I recently upgraded my computer so had to migrate the SQL
server and reporting services.. All of the existing reports run like a
charm.. I just can not get any new ones to run..
Thanks,
Jeff|||Jeffrae wrote:
> Jeffrae wrote:
> > Hello,
> >
> > I am running Microsoft SQL Server 2000.
> >
> > For some reason all of the sudden any subscription I make in reporting
> > services will not run.
> >
> > The status just stays at "New Subscription". I made a test schedule
> > that runs every 5 minutes.
> >
> > I have even added old subscriptions to this schedule and I get email
> > every 5 minutes. Why would any new subscription I make not be running?
> >
> >
> > I don't even get an error message under the status heading in the
> > subscription list.
> >
> >
> > Thanks,
> > Jeff
> Ok... Here is something that I forgot to mention.. This is actually a
> big thing.. I recently upgraded my computer so had to migrate the SQL
> server and reporting services.. All of the existing reports run like a
> charm.. I just can not get any new ones to run..
> Thanks,
> Jeff
Is there another newsgroup that I may want to post this question in?
Thanks,
Jeff

New Subscriptions never show

If I select "New Subscription" and I select a delivery method and time and
select OK, the screen flashes, but no subscriptions are listed. I have the
user as a Browser and Publisher, but I don't get an error. Is there
something else I have to check or setup?
BartNot sure why you are seeing this. Can you look in the subscription table
and see if subscription rows are being added?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bart" <test@.test.com> wrote in message
news:#Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||I got that fixed, but now I can't deliver the subscription.
The Server is 2000 Advanced Server connecting remotely to SQL 2000 on a
Windows 2003 Server.
It looks like an AuthZ problem, but I'm not sure how to resolve it.
Here is the log Info:
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO: Call to
RenderFirst( '/Users Folders/OSCARWEB blynn/My Reports/DVNote Sample' )
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!b7c!06/22/2004-12:35:49:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
"Bart" <test@.test.com> wrote in message
news:%23Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
since weeks. Could you please doublecheck on the properties page of your
reports with details on: Is there some entry like this:
changed by
<name_of_the_user> [unknown]
For me the "unknown" is the key.
Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
with Brian concerning this issue.
r|||It seems that after installing SP1, the problem was resolved. I will
continue testing.
Bart
"Roland" <nomail@.spamprotect.com> wrote in message
news:uPS$4MJWEHA.3236@.tk2msftngp13.phx.gbl...
> Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
> since weeks. Could you please doublecheck on the properties page of your
> reports with details on: Is there some entry like this:
> changed by
> <name_of_the_user> [unknown]
> For me the "unknown" is the key.
> Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
> with Brian concerning this issue.
> r
>|||Oh that sounds good. I will install SP1 on my servers tomorrow and let you
know.
r.|||Bart wrote:
> If I select "New Subscription" and I select a delivery method and
> time and select OK, the screen flashes, but no subscriptions are
> listed. I have the user as a Browser and Publisher, but I don't get
> an error. Is there something else I have to check or setup?
> Bart
Arrgggh... After all those dark days w/o SP1 and a running eMail
subscription I'm now facing a strange problem:
* User with role "Browser" is logging in
* User subscribes to a report
* User is able to enter his eMail (RS is configured as described by Daniel
Reib in thread "Stupid question - how to setup the eMail...")
* The subscription process finishes w/o error message
* The subscription action is performed in time and correctly
-- BUT --
the subscription itself is NOT listed, neither under "My Subscriptions" nor
under the subscription pane of the given report for the user with role
"Browser"
-- BUT -- (Again)
if I login as admin I can view and edit the subscription.
I have currently no access to the logs and so no further info, why the
subscription does not appear for the subscriber itself. Nevermind, probably
one of you has an idea?
roland

New Subscriptions Never Run.

Hello,
For some reason all of the suden any subscription I make will not run..
The status just stays at "New Subscription". I made a test schedule
that runs every 5 minutes.
I have even added old subscriptions to this schedule and I get email
every 5 minutes. Why would Any new subscription I make not be running?
I don't even get an error message under the status heading in the
Subscription list.
Thanks,
JeffJeffrae wrote:
> Hello,
> For some reason all of the sudden any subscription I make will not run..
> The status just stays at "New Subscription". I made a test schedule
> that runs every 5 minutes.
> I have even added old subscriptions to this schedule and I get email
> every 5 minutes. Why would Any new subscription I make not be running?
> I don't even get an error message under the status heading in the
> Subscription list.
> Thanks,
> Jeff
I notice that Subscriptions.MatchData appears to be different then all
of the rest... What is this field?|||Jeffrae wrote:
> Hello,
> For some reason all of the suden any subscription I make will not run..
> The status just stays at "New Subscription". I made a test schedule
> that runs every 5 minutes.
> I have even added old subscriptions to this schedule and I get email
> every 5 minutes. Why would Any new subscription I make not be running?
> I don't even get an error message under the status heading in the
> Subscription list.
> Thanks,
> Jeff
Microsoft SQL Server 2000.

New Subscriptions

When I go to the "My Subscriptions" screem in the Report Manager, I don't get a "New Subscription" option.

I am running SQL Server 2005 Developer's version, as a domain administrator with every role function enabled.

How do I get access to this functionality?

The option is not within "My Subscriptions". You have to have clicked on a report and you will see the option to create a new subscription there.

|||Thanks. Your reply was very helpful. I could have wandered around for hours looking for that.|||I am glad that I was able to help and save you some time!sql

New Data-driven Subscription 'Button'

Hi,
I am trying to set up a data-driven subscription. But the button is not
visible on the subscriptions tab. I have also made sure that
1) the report uses stored credentials.
2) A report that includes parameters.
3) The report server that is configured to use the e-mail delivery
extension.
4) SQL Agent service is running.
5) SQL Server database that contains subscriber information.
Can anybody help?
Snippet from books online:
To open this page, select a report, click the Subscriptions tab at the top
of the page, and then click New Data-driven Subscription. The report must
use stored credentials in order for this button to be enabled.
From this I was expecting to see a button nomatter what.Please read this related newsgroup thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=ba9997ba-d3c3-4ac5-bf9f-6881244ba961&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Phil Koay" <phil.koay@.hydro.com.au> wrote in message
news:%23ijs7P1AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am trying to set up a data-driven subscription. But the button is not
> visible on the subscriptions tab. I have also made sure that
> 1) the report uses stored credentials.
> 2) A report that includes parameters.
> 3) The report server that is configured to use the e-mail delivery
> extension.
> 4) SQL Agent service is running.
> 5) SQL Server database that contains subscriber information.
> Can anybody help?
> Snippet from books online:
> To open this page, select a report, click the Subscriptions tab at the top
> of the page, and then click New Data-driven Subscription. The report must
> use stored credentials in order for this button to be enabled.
> From this I was expecting to see a button nomatter what.
>|||Thanks for such a prompt and accurate response!
I am indeed using the standard edition of Reporting services and that is why
there is no option of "data driven subscriptions"
I have the following scenario:
I work in a company that has a number of SQL Enterprise licences. However I
would be unable to install Report service on any of these machines, or have
the report services database stored on these machine. Do you know if I can
legally:
1. Install Reporting Services Enterprise edition on seperate box (which has
MS SQL Server standard edition installed on it)
2. Use the local 'MS SQL Server standard edition' as the database for the
'Reporting Services Enterprise'
(from the books online is seems that this is ok to do technically see
'Edition compatibility', but is it legal, and will it have all the same
functionality as if stored on a SQL enterprise?)
Thanks!
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:eCrCHX1AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Please read this related newsgroup thread:
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlser
ver.reportingsvcs&mid=ba9997ba-d3c3-4ac5-bf9f-6881244ba961&sloc=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Phil Koay" <phil.koay@.hydro.com.au> wrote in message
> news:%23ijs7P1AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I am trying to set up a data-driven subscription. But the button is not
> > visible on the subscriptions tab. I have also made sure that
> >
> > 1) the report uses stored credentials.
> >
> > 2) A report that includes parameters.
> >
> > 3) The report server that is configured to use the e-mail delivery
> > extension.
> >
> > 4) SQL Agent service is running.
> >
> > 5) SQL Server database that contains subscriber information.
> > Can anybody help?
> >
> > Snippet from books online:
> >
> > To open this page, select a report, click the Subscriptions tab at the
top
> > of the page, and then click New Data-driven Subscription. The report
must
> > use stored credentials in order for this button to be enabled.
> >
> > From this I was expecting to see a button nomatter what.
> >
> >
>|||Note that if you are installing Enterprise you need an enterprise license
for that box. Having Enterprise SQL Servers somewhere else doesn't help. You
can use a remote DB as the object store (RS uses SQL Server to store lots of
things and has to have one around), i.e. RS can be on a different box than
the SQL Server used but as soon as you do that you have to purchase a
license.
I don't know if you can install Enterprise RS using Standard as the object
store. I never tried that. Just wanted to make sure you understand the
licensing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Phil Koay" <phil.koay@.hydro.com.au> wrote in message
news:%23KGYe%232AFHA.824@.TK2MSFTNGP11.phx.gbl...
> Thanks for such a prompt and accurate response!
> I am indeed using the standard edition of Reporting services and that is
why
> there is no option of "data driven subscriptions"
> I have the following scenario:
> I work in a company that has a number of SQL Enterprise licences. However
I
> would be unable to install Report service on any of these machines, or
have
> the report services database stored on these machine. Do you know if I can
> legally:
> 1. Install Reporting Services Enterprise edition on seperate box (which
has
> MS SQL Server standard edition installed on it)
> 2. Use the local 'MS SQL Server standard edition' as the database for the
> 'Reporting Services Enterprise'
> (from the books online is seems that this is ok to do technically see
> 'Edition compatibility', but is it legal, and will it have all the same
> functionality as if stored on a SQL enterprise?)
> Thanks!
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:eCrCHX1AFHA.3120@.TK2MSFTNGP12.phx.gbl...
> > Please read this related newsgroup thread:
> >
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlser
> ver.reportingsvcs&mid=ba9997ba-d3c3-4ac5-bf9f-6881244ba961&sloc=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Phil Koay" <phil.koay@.hydro.com.au> wrote in message
> > news:%23ijs7P1AFHA.2112@.TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > I am trying to set up a data-driven subscription. But the button is
not
> > > visible on the subscriptions tab. I have also made sure that
> > >
> > > 1) the report uses stored credentials.
> > >
> > > 2) A report that includes parameters.
> > >
> > > 3) The report server that is configured to use the e-mail delivery
> > > extension.
> > >
> > > 4) SQL Agent service is running.
> > >
> > > 5) SQL Server database that contains subscriber information.
> > > Can anybody help?
> > >
> > > Snippet from books online:
> > >
> > > To open this page, select a report, click the Subscriptions tab at the
> top
> > > of the page, and then click New Data-driven Subscription. The report
> must
> > > use stored credentials in order for this button to be enabled.
> > >
> > > From this I was expecting to see a button nomatter what.
> > >
> > >
> >
> >
>