I would like to automate a report to be emailed to an email address.
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be other entries in the list too?
ThanksChange to Report Server Email and make sure that the report server is configured for Email Delivery.
Showing posts with label viewing. Show all posts
Showing posts with label viewing. Show all posts
Friday, March 9, 2012
I would like to automate a report to be emailed to an email address.
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be
other entries in the list too?
Thanksyes , you should have 'report serve email ' option too- if you dont, its
because you didnt choose the option at installation time to install SMTP
service.
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>I would like to automate a report to be emailed to an email address.
> When viewing the report, clicked on new subscription.
> In the subscription window what options should there be for Delievered By:
> ?
> I currently have: Report Server File Share in the drop down. Should there
> be
> other entries in the list too?
> Thanks|||How can I add this option whithout affecting the present instal/settings
please?
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||Hello again,
I do not remember seeing the SMTP option during the install.
Please note I am using SSRS 2005. The email we use is loyus notes.
Any thoughts pls?
Thanks
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||OK farshad, in RS2000 you have the option at installation time. For 2005 you
need to use the configuration tool.
See link below for steps:
http://msdn2.microsoft.com/en-us/library/ms159155.aspx
Immy
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:D25E292B-6886-4B0D-AD51-A518AF50BCA8@.microsoft.com...
> Hello again,
> I do not remember seeing the SMTP option during the install.
> Please note I am using SSRS 2005. The email we use is loyus notes.
> Any thoughts pls?
> Thanks
> "Immy" wrote:
>> yes , you should have 'report serve email ' option too- if you dont, its
>> because you didnt choose the option at installation time to install SMTP
>> service.
>> "farshad" <farshad@.discussions.microsoft.com> wrote in message
>> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>> >I would like to automate a report to be emailed to an email address.
>> > When viewing the report, clicked on new subscription.
>> > In the subscription window what options should there be for Delievered
>> > By:
>> > ?
>> > I currently have: Report Server File Share in the drop down. Should
>> > there
>> > be
>> > other entries in the list too?
>> > Thanks
>>
When viewing the report, clicked on new subscription.
In the subscription window what options should there be for Delievered By: ?
I currently have: Report Server File Share in the drop down. Should there be
other entries in the list too?
Thanksyes , you should have 'report serve email ' option too- if you dont, its
because you didnt choose the option at installation time to install SMTP
service.
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>I would like to automate a report to be emailed to an email address.
> When viewing the report, clicked on new subscription.
> In the subscription window what options should there be for Delievered By:
> ?
> I currently have: Report Server File Share in the drop down. Should there
> be
> other entries in the list too?
> Thanks|||How can I add this option whithout affecting the present instal/settings
please?
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||Hello again,
I do not remember seeing the SMTP option during the install.
Please note I am using SSRS 2005. The email we use is loyus notes.
Any thoughts pls?
Thanks
"Immy" wrote:
> yes , you should have 'report serve email ' option too- if you dont, its
> because you didnt choose the option at installation time to install SMTP
> service.
> "farshad" <farshad@.discussions.microsoft.com> wrote in message
> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
> >I would like to automate a report to be emailed to an email address.
> > When viewing the report, clicked on new subscription.
> > In the subscription window what options should there be for Delievered By:
> > ?
> > I currently have: Report Server File Share in the drop down. Should there
> > be
> > other entries in the list too?
> > Thanks
>
>|||OK farshad, in RS2000 you have the option at installation time. For 2005 you
need to use the configuration tool.
See link below for steps:
http://msdn2.microsoft.com/en-us/library/ms159155.aspx
Immy
"farshad" <farshad@.discussions.microsoft.com> wrote in message
news:D25E292B-6886-4B0D-AD51-A518AF50BCA8@.microsoft.com...
> Hello again,
> I do not remember seeing the SMTP option during the install.
> Please note I am using SSRS 2005. The email we use is loyus notes.
> Any thoughts pls?
> Thanks
> "Immy" wrote:
>> yes , you should have 'report serve email ' option too- if you dont, its
>> because you didnt choose the option at installation time to install SMTP
>> service.
>> "farshad" <farshad@.discussions.microsoft.com> wrote in message
>> news:91C6988E-808B-4049-AFA1-3B7A793F0220@.microsoft.com...
>> >I would like to automate a report to be emailed to an email address.
>> > When viewing the report, clicked on new subscription.
>> > In the subscription window what options should there be for Delievered
>> > By:
>> > ?
>> > I currently have: Report Server File Share in the drop down. Should
>> > there
>> > be
>> > other entries in the list too?
>> > Thanks
>>
Wednesday, March 7, 2012
EM frozen when viewing tables
Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual.
I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tool
s?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual
. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client to
ols?
> In any case, you may need to install SP4 on the client. If it happens on t
he
> server, you need to do an impcat analisys before installing SP4. I would n
ot
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
>
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual.
I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tool
s?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual
. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client to
ols?
> In any case, you may need to install SP4 on the client. If it happens on t
he
> server, you need to do an impcat analisys before installing SP4. I would n
ot
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
>
EM frozen when viewing tables
Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? Thanks
Is this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks
|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? Thanks
Is this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks
|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
EM frozen when viewing tables
Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
> > Hi,
> >
> > When I tried to view tables of one my database (sql2000) from Enterprise
> > manger by clicking on Databases --> <database name> --> Tables, it got
> > frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> > close EM and tried several times, it's still the same. How can I
> > troubleshoot? Thanks
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
> > Hi,
> >
> > When I tried to view tables of one my database (sql2000) from Enterprise
> > manger by clicking on Databases --> <database name> --> Tables, it got
> > frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> > close EM and tried several times, it's still the same. How can I
> > troubleshoot? Thanks
Subscribe to:
Posts (Atom)