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 subscription wizard never completes or even errors (SQL 2005 Trans repl with Queued Up

I am testing replication (Transactional with Queued Updating) between SQL
Server 2005 Developer Edition (which is on a domain) and SQL Express (which
is on a machine on same LAN but in a workgroup). I have configured the
publisher as its own distributor and created a publication consisting of 2
views (1 indexed, 1 regular). My problem is that when I run the New
Subscription Wizard, after clicking Finish the process hangs forever on the
first step ("Creating Subscription For ....."). No errors appear, nothing.
Clicking Stop has no effect.
Both views are tiny, only returning half a dozen rows. I have also tried
with a publication containing only one small table, and the same thing
occurs.
The publisher is clearly able to connect to the subscriber because the
linked server is created on the subscriber successfully. There is no sign of
a subscription however on the subscriber.
Here is the configuration for the subscription (following steps in New
Subscription Wizard):
Push subscription
Subscription database is new blank database
Distribution Agent Security: Run under SQL Agent service account, Connects
to distributor by impersonation, Connects to subscriber using a SysAdmin SQL
login
Schedule: runs continuously
Queued updating
Create new linked server using same SysAdmin SQL login as above
Initialize subscription immediately
What could be wrong?
Can you script out your publication creation steps and then run it manually
through Query Analyzer or the SSMS and see where it hangs. This should give
you some indication of where the problem is.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Laurence Neville" <laurenceneville@.hotmail.com> wrote in message
news:eyE7utcAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>I am testing replication (Transactional with Queued Updating) between SQL
>Server 2005 Developer Edition (which is on a domain) and SQL Express (which
>is on a machine on same LAN but in a workgroup). I have configured the
>publisher as its own distributor and created a publication consisting of 2
>views (1 indexed, 1 regular). My problem is that when I run the New
>Subscription Wizard, after clicking Finish the process hangs forever on the
>first step ("Creating Subscription For ....."). No errors appear, nothing.
>Clicking Stop has no effect.
> Both views are tiny, only returning half a dozen rows. I have also tried
> with a publication containing only one small table, and the same thing
> occurs.
> The publisher is clearly able to connect to the subscriber because the
> linked server is created on the subscriber successfully. There is no sign
> of a subscription however on the subscriber.
> Here is the configuration for the subscription (following steps in New
> Subscription Wizard):
> Push subscription
> Subscription database is new blank database
> Distribution Agent Security: Run under SQL Agent service account, Connects
> to distributor by impersonation, Connects to subscriber using a SysAdmin
> SQL login
> Schedule: runs continuously
> Queued updating
> Create new linked server using same SysAdmin SQL login as above
> Initialize subscription immediately
> What could be wrong?
>
|||The step that hangs is the last step - the execution of sp_link_publication
on the subscriber:
exec sp_link_publication @.publisher = N'LAURENCEN\SQL2005', @.publisher_db =
N'RMIS_QA', @.publication = N'test views', @.distributor =
N'LAURENCEN\SQL2005', @.security_mode = 0, @.login = N'xxxxx', @.password =
N'xxxx'
In the Application Event log the following error appears:
MS DTC is unable to communicate with MS DTC on a remote system. No common
RPC protocol is supported between the two systems. Please ensure that one
or more of the following RPC protocols are common to both systems: TCP/IP,
SPX, or NetBEUI. Error Specifics: .\iomgrclt.cpp:204, Pid: 904, CmdLine:
C:\WINNT\System32\msdtc.exe
I have checked that the MSDTC service is running on publisher and
subscriber. The publisher server is Windows XP SP2 and from googling it
looks like DTC is not given network access by default, however I have
enabled the required settings and the error persists:
In Admin tools.Component Services or via Component Services MSC Snap-in
- right-click the appropriate computer node and select properties
- on the MSDTC tab click Security Configuration button
- in addition to the Network DTC Access being ticked, tick Allow Remote
Clients, Allow Inbound, Allow Outbound
- restart MSDTC
The subscriber server is Windows 2000 Workstation, and it doesn't look like
there are any DTC settings to configure.
"Laurence Neville" <laurenceneville@.hotmail.com> wrote in message
news:eyE7utcAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>I am testing replication (Transactional with Queued Updating) between SQL
>Server 2005 Developer Edition (which is on a domain) and SQL Express (which
>is on a machine on same LAN but in a workgroup). I have configured the
>publisher as its own distributor and created a publication consisting of 2
>views (1 indexed, 1 regular). My problem is that when I run the New
>Subscription Wizard, after clicking Finish the process hangs forever on the
>first step ("Creating Subscription For ....."). No errors appear, nothing.
>Clicking Stop has no effect.
> Both views are tiny, only returning half a dozen rows. I have also tried
> with a publication containing only one small table, and the same thing
> occurs.
> The publisher is clearly able to connect to the subscriber because the
> linked server is created on the subscriber successfully. There is no sign
> of a subscription however on the subscriber.
> Here is the configuration for the subscription (following steps in New
> Subscription Wizard):
> Push subscription
> Subscription database is new blank database
> Distribution Agent Security: Run under SQL Agent service account, Connects
> to distributor by impersonation, Connects to subscriber using a SysAdmin
> SQL login
> Schedule: runs continuously
> Queued updating
> Create new linked server using same SysAdmin SQL login as above
> Initialize subscription immediately
> What could be wrong?
>
|||Is this an upgrade from SQL 2000? There are some issues with a remote
distributor in an upgrade. Basically the repl_distributor remote server is
modified to a linked server and there have been cases where you have to
update the passwords to get this to work. AFAIK - MSDTC is not involved in
queued replication.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Laurence Neville" <laurenceneville@.hotmail.com> wrote in message
news:O%237HO7oAHHA.5068@.TK2MSFTNGP02.phx.gbl...
> The step that hangs is the last step - the execution of
> sp_link_publication on the subscriber:
> exec sp_link_publication @.publisher = N'LAURENCEN\SQL2005', @.publisher_db
> = N'RMIS_QA', @.publication = N'test views', @.distributor =
> N'LAURENCEN\SQL2005', @.security_mode = 0, @.login = N'xxxxx', @.password =
> N'xxxx'
> In the Application Event log the following error appears:
> MS DTC is unable to communicate with MS DTC on a remote system. No common
> RPC protocol is supported between the two systems. Please ensure that one
> or more of the following RPC protocols are common to both systems:
> TCP/IP, SPX, or NetBEUI. Error Specifics: .\iomgrclt.cpp:204, Pid: 904,
> CmdLine: C:\WINNT\System32\msdtc.exe
> I have checked that the MSDTC service is running on publisher and
> subscriber. The publisher server is Windows XP SP2 and from googling it
> looks like DTC is not given network access by default, however I have
> enabled the required settings and the error persists:
> In Admin tools.Component Services or via Component Services MSC Snap-in
> - right-click the appropriate computer node and select properties
> - on the MSDTC tab click Security Configuration button
> - in addition to the Network DTC Access being ticked, tick Allow Remote
> Clients, Allow Inbound, Allow Outbound
> - restart MSDTC
> The subscriber server is Windows 2000 Workstation, and it doesn't look
> like there are any DTC settings to configure.
>
> "Laurence Neville" <laurenceneville@.hotmail.com> wrote in message
> news:eyE7utcAHHA.3396@.TK2MSFTNGP02.phx.gbl...
>
|||I figured it out after a long search.
MSDTC is involved, at least to set up the subscription. MSDTC in Windows XP
(and Win 2003 also I think) has some network access settings that are set to
prevent any access from outside by default. I mentioned these before.
However, in addition to setting these settings to allow network access,
there is a security setting for RPC, which I missed. This is the registry
key:
HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Win dows
NT\RPC\RestrictRemoteClients
This needs to exist and have a value of 0 (DWORD) if the subscriber is
Windows 2000.
For more info read:
http://blogs.msdn.com/florinlazar/archive/2004/06/18/159127.aspx
http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx#XSLTsection128121120120
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23tmOUdqAHHA.3536@.TK2MSFTNGP03.phx.gbl...
> Is this an upgrade from SQL 2000? There are some issues with a remote
> distributor in an upgrade. Basically the repl_distributor remote server is
> modified to a linked server and there have been cases where you have to
> update the passwords to get this to work. AFAIK - MSDTC is not involved in
> queued replication.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Laurence Neville" <laurenceneville@.hotmail.com> wrote in message
> news:O%237HO7oAHHA.5068@.TK2MSFTNGP02.phx.gbl...
>

New Subscription - Report Server Email Delivery Method

When I try to create a new subscription no 'Report Server Email Delivery
Method' shows up.
'Report Server Email' does exist in RSReportServer.config and is configured
with a value for <smtpserver> and a value for <from>.
What is required for 'Report Server Email' to show up?When I set this up I had trouble using a name for the server
(servername.blah.com), I had to put in the IP address for it to work for me.
Don't know why.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> When I try to create a new subscription no 'Report Server Email Delivery
> Method' shows up.
> 'Report Server Email' does exist in RSReportServer.config and is
configured
> with a value for <smtpserver> and a value for <from>.
> What is required for 'Report Server Email' to show up?
>|||Was using an IP address.
"Bruce L-C [MVP]" wrote:
> When I set this up I had trouble using a name for the server
> (servername.blah.com), I had to put in the IP address for it to work for me.
> Don't know why.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:59D811E2-233E-45C4-BEFD-F313C9713E34@.microsoft.com...
> > When I try to create a new subscription no 'Report Server Email Delivery
> > Method' shows up.
> >
> > 'Report Server Email' does exist in RSReportServer.config and is
> configured
> > with a value for <smtpserver> and a value for <from>.
> >
> > What is required for 'Report Server Email' to show up?
> >
> >
>
>

New Subscription

We are getting the following error when trying to create a new subscription:
An internal error occurred on the report server. See the error log for more
details.
(rsInternalError) Get Online Help EXECUTE permission denied on object
'xp_sqlagent_is_starting', database 'master', owner 'dbo'.
I can't seem to find what's causing it.
Help'I'm having the same problem...any resolution to this?
"Bob Sherman" wrote:
> We are getting the following error when trying to create a new subscription:
> An internal error occurred on the report server. See the error log for more
> details.
> (rsInternalError) Get Online Help EXECUTE permission denied on object
> 'xp_sqlagent_is_starting', database 'master', owner 'dbo'.
> I can't seem to find what's causing it.
> Help'

New Pull Subscription - Trans Repli - Use old snapshot...

How do I created a new Pull subscription from a transaction replication
publisher without having to run the Sanpshot again?
When I create a new Pull Subscription, it says "Snapshot not ready". After I
run Sanpshot, then it starts.
Running the snapshot forces me to take the production server down for 2
hours, and can not always do this.
Thanks and God Bless,
ThomBeaux
use the concurrent snapshot option. God bless u2.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ThomBeaux" <ThomBeaux@.NoSpam.Com> wrote in message
news:60B3F87F-ED59-4030-B30B-E61B145754C5@.microsoft.com...
> How do I created a new Pull subscription from a transaction replication
> publisher without having to run the Sanpshot again?
> When I create a new Pull Subscription, it says "Snapshot not ready". After
> I
> run Sanpshot, then it starts.
> Running the snapshot forces me to take the production server down for 2
> hours, and can not always do this.
> --
> Thanks and God Bless,
> ThomBeaux
|||What part on the Wizard asks for for the concurrent snapshot optin
Thanks and God Bless,
ThomBeaux
"Hilary Cotter" wrote:

> use the concurrent snapshot option. God bless u2.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "ThomBeaux" <ThomBeaux@.NoSpam.Com> wrote in message
> news:60B3F87F-ED59-4030-B30B-E61B145754C5@.microsoft.com...
>
>
|||As well as Hilary's advice, if you are using SQL Server 2005 there is the
option to "initialize with backup". In the CTP SP2 there is also the option
of 'database snapshot' for the sync type AFAIR.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||after creating your publication right click on it and go to the snapshot
tab, you should find it there. Its something about minimize locking during
snapshot generation.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ThomBeaux" <ThomBeaux@.NoSpam.Com> wrote in message
news:EDD53985-2C00-4151-8902-C08AAC5CEE52@.microsoft.com...[vbcol=seagreen]
> What part on the Wizard asks for for the concurrent snapshot optin
> --
> Thanks and God Bless,
> ThomBeaux
>
> "Hilary Cotter" wrote:

new publication deleted before snapshot completed

I just created a new publication and subscription... And was in the middle
of the synchronization when I dropped the publication...
I am now receiving a 'Could not find stored procedure 'sp_MSins_tablename''
for all of the agents replicating to this server/db.
The error code is 2812.
Anyone encounter this and have an easy solution?
Thanks in advance!
~lb
Hi,
You can remove all the entries manually or use sp_removedbreplication
'databaseName' to start all over again.
Hope this helps.
cheers
"Lonnye Blake Bower" wrote:

> I just created a new publication and subscription... And was in the middle
> of the synchronization when I dropped the publication...
> I am now receiving a 'Could not find stored procedure 'sp_MSins_tablename''
> for all of the agents replicating to this server/db.
> The error code is 2812.
> Anyone encounter this and have an easy solution?
> Thanks in advance!
> ~lb
>
>

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