Configuring a Report Server for E-Mail Delivery

I've installed Report Services and need to setup the E-Mail Delivery.
There are documents like 'Configuring a Report Server for E-Mail Delivery'
that talk about entering values in the SMTPServer field in the
rswebapplication.config file, but there isn't enough specific information
about setting up e-mail delivery.
What needs to be done to setup e-mail delivery?
Thanks,
JimAre you just talking about a basic subscription? If so, during the
installation you were asked for an smtp server.
That should be all it takes. You might try to create a subscription and
see what happens.
You can also edit the config file and change the SMTP server, but I have
no experience with that.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:Jim@.discussions.microsoft.com:
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||It can be done during installation but otherwise just do the following:
If you have a smtp server somewhere then you can just use that and use the
mail client that comes with Reporting Services. That is what I do.
In rsreportserver.config look for:
<SMTPServer>123.45.6.78</SMTPServer>
and put in the address for your smtp server. I found I had to hardcode the
address rather than use the name.
Also put in this one as well:
<From>somebody@.somewhere.com</From>
These two are the minimum to put in. There are more items you can configure
but those two should get you going.
Of course, for this to work you smtp server needs to accept mail from
anonymous sources. If it doesn't then there is more you will have to do (in
my case I didn't so I can't help with that scenario).
Hopefully this gets you going in the right direction.
Note that you do not need any mail client installed on the server. RS just
sends your mail to an existing smtp server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||Report Services were installed before the SMTP server, so I would like to
configure the email server without removing the Report Services.
Did try a subscription and it did not work.
"John Geddes" wrote:
> Are you just talking about a basic subscription? If so, during the
> installation you were asked for an smtp server.
> That should be all it takes. You might try to create a subscription and
> see what happens.
> You can also edit the config file and change the SMTP server, but I have
> no experience with that.
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:Jim@.discussions.microsoft.com:
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> >
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> >
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||What structure in the rsreportserver.config do the values belong in?
"Bruce L-C [MVP]" wrote:
> It can be done during installation but otherwise just do the following:
> If you have a smtp server somewhere then you can just use that and use the
> mail client that comes with Reporting Services. That is what I do.
> In rsreportserver.config look for:
> <SMTPServer>123.45.6.78</SMTPServer>
> and put in the address for your smtp server. I found I had to hardcode the
> address rather than use the name.
> Also put in this one as well:
> <From>somebody@.somewhere.com</From>
> These two are the minimum to put in. There are more items you can configure
> but those two should get you going.
> Of course, for this to work you smtp server needs to accept mail from
> anonymous sources. If it doesn't then there is more you will have to do (in
> my case I didn't so I can't help with that scenario).
> Hopefully this gets you going in the right direction.
> Note that you do not need any mail client installed on the server. RS just
> sends your mail to an existing smtp server.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||The lines are already in there, you do not need to put them in, just search
for them and put your values in.
I.e. you will see this:
<SMTPServer></SMTPServer>
and you need to make it look like this
<SMTPServer>123.45.6.78</SMTPServer>
except, of course, put in the ip address. I had no luck putting the name in
for some reason so I put the IP address instead
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> What structure in the rsreportserver.config do the values belong in?
> "Bruce L-C [MVP]" wrote:
> > It can be done during installation but otherwise just do the following:
> >
> > If you have a smtp server somewhere then you can just use that and use
the
> > mail client that comes with Reporting Services. That is what I do.
> >
> > In rsreportserver.config look for:
> > <SMTPServer>123.45.6.78</SMTPServer>
> > and put in the address for your smtp server. I found I had to hardcode
the
> > address rather than use the name.
> >
> > Also put in this one as well:
> > <From>somebody@.somewhere.com</From>
> >
> > These two are the minimum to put in. There are more items you can
configure
> > but those two should get you going.
> >
> > Of course, for this to work you smtp server needs to accept mail from
> > anonymous sources. If it doesn't then there is more you will have to do
(in
> > my case I didn't so I can't help with that scenario).
> >
> > Hopefully this gets you going in the right direction.
> >
> > Note that you do not need any mail client installed on the server. RS
just
> > sends your mail to an existing smtp server.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> >
> > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > I've installed Report Services and need to setup the E-Mail Delivery.
> > >
> > > There are documents like 'Configuring a Report Server for E-Mail
Delivery'
> > > that talk about entering values in the SMTPServer field in the
> > > rswebapplication.config file, but there isn't enough specific
information
> > > about setting up e-mail delivery.
> > >
> > > What needs to be done to setup e-mail delivery?
> > >
> > > Thanks,
> > > Jim
> >
> >
> >|||The lines aren't in the file I have.
"Bruce L-C [MVP]" wrote:
> The lines are already in there, you do not need to put them in, just search
> for them and put your values in.
> I.e. you will see this:
> <SMTPServer></SMTPServer>
> and you need to make it look like this
> <SMTPServer>123.45.6.78</SMTPServer>
> except, of course, put in the ip address. I had no luck putting the name in
> for some reason so I put the IP address instead
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> > What structure in the rsreportserver.config do the values belong in?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > It can be done during installation but otherwise just do the following:
> > >
> > > If you have a smtp server somewhere then you can just use that and use
> the
> > > mail client that comes with Reporting Services. That is what I do.
> > >
> > > In rsreportserver.config look for:
> > > <SMTPServer>123.45.6.78</SMTPServer>
> > > and put in the address for your smtp server. I found I had to hardcode
> the
> > > address rather than use the name.
> > >
> > > Also put in this one as well:
> > > <From>somebody@.somewhere.com</From>
> > >
> > > These two are the minimum to put in. There are more items you can
> configure
> > > but those two should get you going.
> > >
> > > Of course, for this to work you smtp server needs to accept mail from
> > > anonymous sources. If it doesn't then there is more you will have to do
> (in
> > > my case I didn't so I can't help with that scenario).
> > >
> > > Hopefully this gets you going in the right direction.
> > >
> > > Note that you do not need any mail client installed on the server. RS
> just
> > > sends your mail to an existing smtp server.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > >
> > >
> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > > I've installed Report Services and need to setup the E-Mail Delivery.
> > > >
> > > > There are documents like 'Configuring a Report Server for E-Mail
> Delivery'
> > > > that talk about entering values in the SMTPServer field in the
> > > > rswebapplication.config file, but there isn't enough specific
> information
> > > > about setting up e-mail delivery.
> > > >
> > > > What needs to be done to setup e-mail delivery?
> > > >
> > > > Thanks,
> > > > Jim
> > >
> > >
> > >
>
>|||Are you sure? Are you looking at rsreportserver.config , there is more than
one configuration file.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> The lines aren't in the file I have.
> "Bruce L-C [MVP]" wrote:
>> The lines are already in there, you do not need to put them in, just
>> search
>> for them and put your values in.
>> I.e. you will see this:
>> <SMTPServer></SMTPServer>
>> and you need to make it look like this
>> <SMTPServer>123.45.6.78</SMTPServer>
>> except, of course, put in the ip address. I had no luck putting the name
>> in
>> for some reason so I put the IP address instead
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
>> > What structure in the rsreportserver.config do the values belong in?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > It can be done during installation but otherwise just do the
>> > > following:
>> > >
>> > > If you have a smtp server somewhere then you can just use that and
>> > > use
>> the
>> > > mail client that comes with Reporting Services. That is what I do.
>> > >
>> > > In rsreportserver.config look for:
>> > > <SMTPServer>123.45.6.78</SMTPServer>
>> > > and put in the address for your smtp server. I found I had to
>> > > hardcode
>> the
>> > > address rather than use the name.
>> > >
>> > > Also put in this one as well:
>> > > <From>somebody@.somewhere.com</From>
>> > >
>> > > These two are the minimum to put in. There are more items you can
>> configure
>> > > but those two should get you going.
>> > >
>> > > Of course, for this to work you smtp server needs to accept mail from
>> > > anonymous sources. If it doesn't then there is more you will have to
>> > > do
>> (in
>> > > my case I didn't so I can't help with that scenario).
>> > >
>> > > Hopefully this gets you going in the right direction.
>> > >
>> > > Note that you do not need any mail client installed on the server. RS
>> just
>> > > sends your mail to an existing smtp server.
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > >
>> > >
>> > >
>> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
>> > > > I've installed Report Services and need to setup the E-Mail
>> > > > Delivery.
>> > > >
>> > > > There are documents like 'Configuring a Report Server for E-Mail
>> Delivery'
>> > > > that talk about entering values in the SMTPServer field in the
>> > > > rswebapplication.config file, but there isn't enough specific
>> information
>> > > > about setting up e-mail delivery.
>> > > >
>> > > > What needs to be done to setup e-mail delivery?
>> > > >
>> > > > Thanks,
>> > > > Jim
>> > >
>> > >
>> > >
>>|||Bruce,
You were right. It was the wrong file.
Thanks,
Jim
"Bruce L-C [MVP]" wrote:
> Are you sure? Are you looking at rsreportserver.config , there is more than
> one configuration file.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> > The lines aren't in the file I have.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The lines are already in there, you do not need to put them in, just
> >> search
> >> for them and put your values in.
> >>
> >> I.e. you will see this:
> >> <SMTPServer></SMTPServer>
> >> and you need to make it look like this
> >> <SMTPServer>123.45.6.78</SMTPServer>
> >> except, of course, put in the ip address. I had no luck putting the name
> >> in
> >> for some reason so I put the IP address instead
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> >> > What structure in the rsreportserver.config do the values belong in?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> > > It can be done during installation but otherwise just do the
> >> > > following:
> >> > >
> >> > > If you have a smtp server somewhere then you can just use that and
> >> > > use
> >> the
> >> > > mail client that comes with Reporting Services. That is what I do.
> >> > >
> >> > > In rsreportserver.config look for:
> >> > > <SMTPServer>123.45.6.78</SMTPServer>
> >> > > and put in the address for your smtp server. I found I had to
> >> > > hardcode
> >> the
> >> > > address rather than use the name.
> >> > >
> >> > > Also put in this one as well:
> >> > > <From>somebody@.somewhere.com</From>
> >> > >
> >> > > These two are the minimum to put in. There are more items you can
> >> configure
> >> > > but those two should get you going.
> >> > >
> >> > > Of course, for this to work you smtp server needs to accept mail from
> >> > > anonymous sources. If it doesn't then there is more you will have to
> >> > > do
> >> (in
> >> > > my case I didn't so I can't help with that scenario).
> >> > >
> >> > > Hopefully this gets you going in the right direction.
> >> > >
> >> > > Note that you do not need any mail client installed on the server. RS
> >> just
> >> > > sends your mail to an existing smtp server.
> >> > >
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> >> > > > I've installed Report Services and need to setup the E-Mail
> >> > > > Delivery.
> >> > > >
> >> > > > There are documents like 'Configuring a Report Server for E-Mail
> >> Delivery'
> >> > > > that talk about entering values in the SMTPServer field in the
> >> > > > rswebapplication.config file, but there isn't enough specific
> >> information
> >> > > > about setting up e-mail delivery.
> >> > > >
> >> > > > What needs to be done to setup e-mail delivery?
> >> > > >
> >> > > > Thanks,
> >> > > > Jim
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

Configuring a Report Server for E-Mail Delivery

Bruce
I am pretty much in the same boat I have setup a test reporting
services instance on a Windows 2003 box. I now want to setup the
WIndows SMTP server and make reporting services send emails to the
SMTP server running on Windows.
Your help would be highly appreciated if you can specify the steps in
setting up Windows 2003 SMTP server and making reporting services talk
to it.
Thanks
KarenI have not setup the SMTP server. I use Reporting Services ability to be a
client and have it send to an existing SMTP server. There should be no
difference with the setup for Reporting Services, it just needs a SMTP
server, regardless of where it is. So what you need to know is how to
install and setup Windows SMTP server. Two different things, Report Services
SMTP client support and SMTP server. One option once you have the SMTP
server working is you can have RS deposite the report in a directory that
then the SMTP server picks up and emails or you can have it send the report
to the SMTP server which then forwards it on its way. For SMTP Server help I
would check out a Windows 2003 newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0501062053.763b670e@.posting.google.com...
> Bruce
> I am pretty much in the same boat I have setup a test reporting
> services instance on a Windows 2003 box. I now want to setup the
> WIndows SMTP server and make reporting services send emails to the
> SMTP server running on Windows.
> Your help would be highly appreciated if you can specify the steps in
> setting up Windows 2003 SMTP server and making reporting services talk
> to it.
> Thanks
> Karen

Configure Server for Email Delivery

I am having trouble getting a report emailed for the first time.
The timed subscription has been set. I have updated the ReportServer.config
file to include the ip of the exchange server along with port number although
im not sure where to enter a password. The IT guys are making sure that the
exchange server will accept smtp requests from other servers. My question is
what is the best method to troubleshoot & is there anything gleeming that i
am missing. ThanksI have noted that the sql server agent has a job logged & shows suceeded when
last run but I have recieved any emails. I have also noted a job in the
process info that has a status of sleeping. Event log shows nothing
"Tango" wrote:
> I am having trouble getting a report emailed for the first time.
> The timed subscription has been set. I have updated the ReportServer.config
> file to include the ip of the exchange server along with port number although
> im not sure where to enter a password. The IT guys are making sure that the
> exchange server will accept smtp requests from other servers. My question is
> what is the best method to troubleshoot & is there anything gleeming that i
> am missing. Thanks|||Can anyone help, please. Maybe a link to a ReportServer.config that is
successfully emailing reports might help.
Thankyou
"Tango" wrote:
> I have noted that the sql server agent has a job logged & shows suceeded when
> last run but I have recieved any emails. I have also noted a job in the
> process info that has a status of sleeping. Event log shows nothing
> "Tango" wrote:
> > I am having trouble getting a report emailed for the first time.
> > The timed subscription has been set. I have updated the ReportServer.config
> > file to include the ip of the exchange server along with port number although
> > im not sure where to enter a password. The IT guys are making sure that the
> > exchange server will accept smtp requests from other servers. My question is
> > what is the best method to troubleshoot & is there anything gleeming that i
> > am missing. Thanks|||Tango,
Did you ever find out an answer to this? If so could you please share it?
"Tango" wrote:
> Can anyone help, please. Maybe a link to a ReportServer.config that is
> successfully emailing reports might help.
> Thankyou
> "Tango" wrote:
> > I have noted that the sql server agent has a job logged & shows suceeded when
> > last run but I have recieved any emails. I have also noted a job in the
> > process info that has a status of sleeping. Event log shows nothing
> >
> > "Tango" wrote:
> >
> > > I am having trouble getting a report emailed for the first time.
> > > The timed subscription has been set. I have updated the ReportServer.config
> > > file to include the ip of the exchange server along with port number although
> > > im not sure where to enter a password. The IT guys are making sure that the
> > > exchange server will accept smtp requests from other servers. My question is
> > > what is the best method to troubleshoot & is there anything gleeming that i
> > > am missing. Thanks|||It is notoriously difficult to get the subscriptions to work, I spent a week
configuring a production server trying to do this and gave up, I have the
feeling you need to re-install RS using different accounts/settings, which in
my case wasn't an option. I ended up coding a small windows service that
downloaded the report through a crafted URL and emailed it based on a
schedule in a table. It actually took less to code that snippet than to
configure the much glorified data driven subscription feature of RS.
Microsoft shouldn't be in such a hurry to advertise features that won't even
work in plain vanilla, no frills install out of the box.
Regards,
Tzepesh
"Tango" wrote:
> Can anyone help, please. Maybe a link to a ReportServer.config that is
> successfully emailing reports might help.
> Thankyou
> "Tango" wrote:
> > I have noted that the sql server agent has a job logged & shows suceeded when
> > last run but I have recieved any emails. I have also noted a job in the
> > process info that has a status of sleeping. Event log shows nothing
> >
> > "Tango" wrote:
> >
> > > I am having trouble getting a report emailed for the first time.
> > > The timed subscription has been set. I have updated the ReportServer.config
> > > file to include the ip of the exchange server along with port number although
> > > im not sure where to enter a password. The IT guys are making sure that the
> > > exchange server will accept smtp requests from other servers. My question is
> > > what is the best method to troubleshoot & is there anything gleeming that i
> > > am missing. Thanks|||Report server will only work against an SMTP server that accepts anonymous
or NTLM authentication. The best solution for email is to use a local SMTP
server as a relay to your smtp server. Set the pickup directory element in
the RSReportServer.config file to the local SMTP servers pickup directory
and the SendUsing element to 1. Then configure your local SMTP server to
relay the email to your actual SMTP server.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tzepesh" <Tzepesh@.discussions.microsoft.com> wrote in message
news:547E777A-F7A3-4F9A-A7AA-236F22E04966@.microsoft.com...
> It is notoriously difficult to get the subscriptions to work, I spent a
> week
> configuring a production server trying to do this and gave up, I have the
> feeling you need to re-install RS using different accounts/settings, which
> in
> my case wasn't an option. I ended up coding a small windows service that
> downloaded the report through a crafted URL and emailed it based on a
> schedule in a table. It actually took less to code that snippet than to
> configure the much glorified data driven subscription feature of RS.
> Microsoft shouldn't be in such a hurry to advertise features that won't
> even
> work in plain vanilla, no frills install out of the box.
> Regards,
> Tzepesh
> "Tango" wrote:
>> Can anyone help, please. Maybe a link to a ReportServer.config that is
>> successfully emailing reports might help.
>> Thankyou
>> "Tango" wrote:
>> > I have noted that the sql server agent has a job logged & shows
>> > suceeded when
>> > last run but I have recieved any emails. I have also noted a job in the
>> > process info that has a status of sleeping. Event log shows nothing
>> >
>> > "Tango" wrote:
>> >
>> > > I am having trouble getting a report emailed for the first time.
>> > > The timed subscription has been set. I have updated the
>> > > ReportServer.config
>> > > file to include the ip of the exchange server along with port number
>> > > although
>> > > im not sure where to enter a password. The IT guys are making sure
>> > > that the
>> > > exchange server will accept smtp requests from other servers. My
>> > > question is
>> > > what is the best method to troubleshoot & is there anything gleeming
>> > > that i
>> > > am missing. Thanks

Configure Report Server for e-mail delivery

Hi,
How do I configure report server for e-mail delivery
Thanks> sanvaceswrote
Hi
> How do I configure report server for e-mail deliver
> Thank
Ther are two ypes of subscription
1. Static subscription (I call it
2. Data driven subscription
Steps
1. Open report manage
Start - Programs - Microsoft SQL server - Reporting services -
Report manage
2. Open the particular repor
a. If you want static subscription (ie Just one mail id
1. Click the New subscription butto
2. Fill in the fields with all required value
3. At the end of the page you will have textbox for the
report parameter - Fill the with required valu
4.In the same page there will be Subscription Processin
Option
a. Click the select schedule butto
b. The subscription page appeare
c. Schedule your subscription as required hea
and click ok
d. The in subscription page click o
This steps conforms your subscriptio
Note
1. To make a auto matic subscription running You need to have Sq
server agent running
2. You should have set the reporting services configured for SMT
serve
O
Revert back for any clarificatio|||Hi,
thanks for the response, but I belive I need to configure the report server
config file and that's the area that I'm getting lost, do you know if I could
exchange server instead of outlook account? I was reading about it yesterday
on MSND but is really not clear the process to configure this file. Any help
woulb be appreciated
"mramakrishnanm" wrote:
> > sanvaceswrote:
> Hi,
> > How do I configure report server for e-mail delivery
> >
> > Thanks
> Ther are two ypes of subscriptions
> 1. Static subscription (I call it)
> 2. Data driven subscriptions
> Steps:
> 1. Open report manager
> Start - Programs - Microsoft SQL server - Reporting services -
> Report manager
> 2. Open the particular repore
> a. If you want static subscription (ie Just one mail id)
> 1. Click the New subscription button
> 2. Fill in the fields with all required values
> 3. At the end of the page you will have textbox for the
> report parameter - Fill the with required value
> 4.In the same page there will be Subscription Processing
> Options
> a. Click the select schedule button
> b. The subscription page appeares
> c. Schedule your subscription as required hear
> and click ok.
> d. The in subscription page click ok
> This steps conforms your subscription
> Note:
> 1. To make a auto matic subscription running You need to have Sql
> server agent running.
> 2. You should have set the reporting services configured for SMTP
> server
> Ok
> Revert back for any clarification
>|||I am home sick and I don't have the exact info for you, but let me give you
the concept. You need a SMTP server. Exchange can definitely act as that. I
use a Unix server as mine. You put in the address in the config file (I
always had to use the IP address rather than the name). The other option is
to configure 2003 to be a SMTP server. Then have a dropbox directory where
you deposit the file for delivery and it is picked up and delivered. I have
never done this, I didn't want to make by environment any more complicated
than necessary.
You definitely do not need an outlook account. I am not even sure whether
you can. RS can do two things, it can send mail to a SMTP server (either
anonymously or using a particular username/password) or it can deposit into
a directory where another program picks it up and mails it.
Note that if you are going to use SMTP with a remote computer you really
need to have SP2 installed. It never worked for me until I did that.
Here is a link to another posting of mine using google groups to find it. I
searched google groups for loehle and smtp and found this right away.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/c3da2e72680a975b/5437d4edab8c4a46?lnk=st&q=loehle+smtp&rnum=1&hl=en#5437d4edab8c4a46
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sanvaces" <sanvaces@.discussions.microsoft.com> wrote in message
news:A571EE9F-B9F6-46B3-8C62-29EE02C9AA7E@.microsoft.com...
> Hi,
> thanks for the response, but I belive I need to configure the report
> server
> config file and that's the area that I'm getting lost, do you know if I
> could
> exchange server instead of outlook account? I was reading about it
> yesterday
> on MSND but is really not clear the process to configure this file. Any
> help
> woulb be appreciated
> "mramakrishnanm" wrote:
>> > sanvaceswrote:
>> Hi,
>> > How do I configure report server for e-mail delivery
>> >
>> > Thanks
>> Ther are two ypes of subscriptions
>> 1. Static subscription (I call it)
>> 2. Data driven subscriptions
>> Steps:
>> 1. Open report manager
>> Start - Programs - Microsoft SQL server - Reporting services -
>> Report manager
>> 2. Open the particular repore
>> a. If you want static subscription (ie Just one mail id)
>> 1. Click the New subscription button
>> 2. Fill in the fields with all required values
>> 3. At the end of the page you will have textbox for the
>> report parameter - Fill the with required value
>> 4.In the same page there will be Subscription Processing
>> Options
>> a. Click the select schedule button
>> b. The subscription page appeares
>> c. Schedule your subscription as required hear
>> and click ok.
>> d. The in subscription page click ok
>> This steps conforms your subscription
>> Note:
>> 1. To make a auto matic subscription running You need to have Sql
>> server agent running.
>> 2. You should have set the reporting services configured for SMTP
>> server
>> Ok
>> Revert back for any clarification
>>|||Bruce,
thanks for your help and I hope you get better the google are is a great
area for help and support.
Due to the tigh security in our email server I ending using a third party
software on Microsoft Outlook that work really great you could schedule any
email with attachments with it (from Sperry Software) it only cost $24 and I
just change the report to be saved in a file instead of email. It would be
really nice if the new release will a have a simpler way to send email.
Thanks
"Bruce L-C [MVP]" wrote:
> I am home sick and I don't have the exact info for you, but let me give you
> the concept. You need a SMTP server. Exchange can definitely act as that. I
> use a Unix server as mine. You put in the address in the config file (I
> always had to use the IP address rather than the name). The other option is
> to configure 2003 to be a SMTP server. Then have a dropbox directory where
> you deposit the file for delivery and it is picked up and delivered. I have
> never done this, I didn't want to make by environment any more complicated
> than necessary.
> You definitely do not need an outlook account. I am not even sure whether
> you can. RS can do two things, it can send mail to a SMTP server (either
> anonymously or using a particular username/password) or it can deposit into
> a directory where another program picks it up and mails it.
> Note that if you are going to use SMTP with a remote computer you really
> need to have SP2 installed. It never worked for me until I did that.
> Here is a link to another posting of mine using google groups to find it. I
> searched google groups for loehle and smtp and found this right away.
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/c3da2e72680a975b/5437d4edab8c4a46?lnk=st&q=loehle+smtp&rnum=1&hl=en#5437d4edab8c4a46
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sanvaces" <sanvaces@.discussions.microsoft.com> wrote in message
> news:A571EE9F-B9F6-46B3-8C62-29EE02C9AA7E@.microsoft.com...
> > Hi,
> >
> > thanks for the response, but I belive I need to configure the report
> > server
> > config file and that's the area that I'm getting lost, do you know if I
> > could
> > exchange server instead of outlook account? I was reading about it
> > yesterday
> > on MSND but is really not clear the process to configure this file. Any
> > help
> > woulb be appreciated
> >
> > "mramakrishnanm" wrote:
> >
> >> > sanvaceswrote:
> >> Hi,
> >> > How do I configure report server for e-mail delivery
> >> >
> >> > Thanks
> >>
> >> Ther are two ypes of subscriptions
> >> 1. Static subscription (I call it)
> >> 2. Data driven subscriptions
> >>
> >> Steps:
> >> 1. Open report manager
> >> Start - Programs - Microsoft SQL server - Reporting services -
> >> Report manager
> >> 2. Open the particular repore
> >> a. If you want static subscription (ie Just one mail id)
> >> 1. Click the New subscription button
> >> 2. Fill in the fields with all required values
> >> 3. At the end of the page you will have textbox for the
> >> report parameter - Fill the with required value
> >> 4.In the same page there will be Subscription Processing
> >> Options
> >> a. Click the select schedule button
> >> b. The subscription page appeares
> >> c. Schedule your subscription as required hear
> >> and click ok.
> >> d. The in subscription page click ok
> >> This steps conforms your subscription
> >>
> >> Note:
> >> 1. To make a auto matic subscription running You need to have Sql
> >> server agent running.
> >> 2. You should have set the reporting services configured for SMTP
> >> server
> >>
> >> Ok
> >> Revert back for any clarification
> >>
> >>
>
>