outlook web access - weird

I have subscriptions setup to deliver reports in PDF format to users email
address. No problem there. When the email is opened in the Outlook client,
the attachment appears as expected and can be opened. The problem is when
the user accesses their email using Outlook web access (OWA). The email
appears and even has the paper clip identifying the attachment. However,
when the email is opened. the attachment is gone."chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:F54988C0-2987-484D-AE80-F0B50F002E1D@.microsoft.com...
>I have subscriptions setup to deliver reports in PDF format to users email
> address. No problem there. When the email is opened in the Outlook
> client,
> the attachment appears as expected and can be opened. The problem is when
> the user accesses their email using Outlook web access (OWA). The email
> appears and even has the paper clip identifying the attachment. However,
> when the email is opened. the attachment is gone.
Can they open other pdf-files from their OWA?
Any security settings in play?
Did they test their OWA on a machine they knew there was a PDF-reader
installed on?
I know that sometimes I need to download pdf-files on my computer before
opening them in my OWA. But I'm quite sure the link for downloading is there
when I open the message, though.
Kaisa M. Lindahl|||they can open other pdf's through OWA, just not the ones delivered through
reporting services.
"Kaisa M. Lindahl" wrote:
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:F54988C0-2987-484D-AE80-F0B50F002E1D@.microsoft.com...
> >I have subscriptions setup to deliver reports in PDF format to users email
> > address. No problem there. When the email is opened in the Outlook
> > client,
> > the attachment appears as expected and can be opened. The problem is when
> > the user accesses their email using Outlook web access (OWA). The email
> > appears and even has the paper clip identifying the attachment. However,
> > when the email is opened. the attachment is gone.
> Can they open other pdf-files from their OWA?
> Any security settings in play?
> Did they test their OWA on a machine they knew there was a PDF-reader
> installed on?
> I know that sometimes I need to download pdf-files on my computer before
> opening them in my OWA. But I'm quite sure the link for downloading is there
> when I open the message, though.
> Kaisa M. Lindahl
>
>

Orphaned Subscriptions

Running Win2k & SQL 2k
How do I remove orphaned subscriptions? I have several subscriptions that
appear in the distribution agent of the publisher that do not exist on the
subscriber.
Is there an SP to remove these? Is there a way I can do it manually?
TIA,
Larry...
It seems that ActiveX distribution and merge agents, as well as the merge
agents created with SQL CE subscribers are prone to not being cleaned up
correctly. Or perhpas I'm doing something incorrect.
First off make sure the agents aren't still running at the publisher. Use
sp_MSenum_replication_agents to determine the names of the active agents.
You have to pass the agent type
1=snapshot
2=logreader
3=distribution
4=merge
5=misc
9=queue reader
Then you have to determine the agent status, to do this change to the
distribution database and issue the following
sp_MSenum_distribution 'AgentName'
0=initializing
1=starting
2=stopped
3=running
4=idle
5=retry
6=failed
Once you have figured out the agent status you can begin to delete them.
In your subscription database issue an sp_helpsubscription or
sp_helpmergesubscription
Delete the subscription using sp_dropsubscription or
spdropmergesubscription. Use the values obtained from the above two
commands. Issue this in the publication database.
If this doesn't work you have to manually edit the system tables.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:A1882E7A-AFCC-4A56-A07E-2B93BDDD6F6B@.microsoft.com...
> Running Win2k & SQL 2k
> How do I remove orphaned subscriptions? I have several subscriptions that
> appear in the distribution agent of the publisher that do not exist on the
> subscriber.
> Is there an SP to remove these? Is there a way I can do it manually?
> TIA,
> Larry...